shp2pgsql Help with syntax

[SenTnel]

Hi! New to postgres, im trying to import shapefiles into postgres 8.2
using shp2pgsql but so far have failed.

I tryed using the -p option just to prepare / create the tables then
insert the data, but no luck, please help me writing the correct
syntax to acomplish for the following:


Shapefile named "callesnac. shp"
Database "postgres" (postgres default installation)
Schema "sky"

Need:

Create table "callesnac"
Add column "gid" integer / not null default / next val
Add column "clasificac_via s" varchar

import / insert all the data from "callesnac. shp" into
callesnac table.

Thanks!

[michaelb]

You should probably review the PostGIS Manual and read specifically this section on Using the Loader
It has the list of command line switches and example on uploading the shape file.