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.