About

shp2pgsql is a command line tool that converts a shapefile into a series of SQL commands that can be loaded into a PostGIS/PostgreSQL database. The output of this command can be captured in a SQL file or piped directly to the psql command, which will execute the commands against a target database. The tool is included in PostGIS.