shp2pgsql Help with sintax!

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_vias"  varchar

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

Thanks!
--
View this message in context: http://www.nabble.com/shp2pgsql-Help-with-sintax%21-tf4098088.html#a11653333
Sent from the PostgreSQL - general mailing list archive at Nabble.com.