Search Postgresql Archives

shp2pgsql Help with sintax!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux