By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

shp2pgsql Help with syntax

P: 1
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"


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.

Jul 17 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 534
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.
Jul 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.