Navigate to the folder where your shape files are located: In my case it is D:\Georgia DB\Geology.
Find location of the shp2pgsql executable: Usually in C:\Program Files\Postgres\8.*\bin\

Launch shp2pgsql with CMD with commandline options:

D:\Georgia DB\Geology> C:\Program Files\PostgreSQL\8.4\bin\shp2pgsql settlements public.settlements > settlements.sql

--That will generate set of sql statement for insert

"C:\Program Files\PostgreSQL\8.4\bin\shp2pgsql" -s 2467  -I  -W LATIN1 settlements public.settlements > settlements.sql

After use psql to dump the resulting settlements.sql:


"C:\Program Files\PostgreSQL\8.4\bin\psql" -d georgia -U postgres -f settlements.sql