Shapefile to PostGIS table.

import-shp-to-pgsql.sh

# SRID is the projection's EPSG code. To find yours, open up the prj file in a text editor and search for that name at http://spatialreference.org/
# The schema is probably already named `public` and the database name is perhaps your username.
# To list your schemas use `\dn` after running `psql`.
# To get info about your current database connnection use `\conninfo`.
# In SQL, get the database name with `select current_database() ;`
# The -D flag will use the postgres dump format, which will be much faster than single row inserts. if any single row fails,
# which is also good to know — instead of not knowing if you insert row by row

# shp2pgsql -I -D -s <SRID> <PATH/TO/SHAPEFILE> <SCHEMA>.<DBTABLE> | psql -d <DATABASE>

shp2pgsql -I -D -s 4629 Tract_2010Census_DP1.shp public.census_tracts | psql -d mike

# 4629 is the EPSG code for NAD83, use 4326 if you're importing lat/lng data