[postgis-users] pgsql2shp syntax - sentence construction
elvin.pimentel at gmail.com
Mon Jun 2 17:46:25 PDT 2008
I must admit that Im not good at this, but Im determined to mantain my
city's database correcting names and roads classifications, etc., that's why
I need to take the postgres data and convert it to shapefile, then correct
things with arcmap, then drop the old postgres data and then re-convert the
updated shapefile to postgres, is this the way you would do it?
I have one more question about this updating, and this is a "select"
question, (I'll remind you that Im an ignorant in this matters) would you
please construct an sql sentence to achive this:
In mydatabase, myschema, mytable there's a "street" column, where the street
names are, let's say I want to correct a misspeled name, for example, "Geoge
Washington", and want to correct it to "George Washington", how do you write
Stephen Woodbridge wrote:
> SenTnel wrote:
>> Hi! Im working with postgres and geoserver but im just not good at sql
>> statements, none the less in construction sentences in postgres, and I
>> like to create a shapefile from a table in postgres and don't want to
>> make a
>> costly mistake, so if you help me achieve this using pgsql2shp:
>> database name: mydatabase
>> schema: myschema
>> table: mytable
>> shapefile to be created: updatedshp
>> database user: postgres
>> password: any
>> can you help me with the syntax to achieve the shapefile containing all
>> the data (and geom) in such table?
>> Thanks !
> pgsql2shp is not a SQL statement it is a command line tool:
> woodbri at carto:~$ pgsql2shp
> RCSID: $Id: pgsql2shp.c,v 1.82 2006/01/16 10:42:57 strk Exp $
> USAGE: pgsql2shp [<options>] <database> [<schema>.]<table>
> pgsql2shp [<options>] <database> <query>
> -f <filename> Use this option to specify the name of the file
> to create.
> -h <host> Allows you to specify connection to a database on a
> machine other than the default.
> -p <port> Allows you to specify a database port other than the
> -P <password> Connect to the database with the specified password.
> -u <user> Connect to the database as the specified user.
> -g <geometry_column> Specify the geometry column to be exported.
> -b Use a binary cursor.
> -r Raw mode. Do not assume table has been created by
> the loader. This would not unescape attribute names
> and will not skip the 'gid' attribute.
> -k Keep postgresql identifiers case.
> So you might use it like:
>> pgsql2shp -f updatedshp.shp -h localhost -u postgres mydatabase
> Have fun,
> -Steve W
> postgis-users mailing list
> postgis-users at postgis.refractions.net
View this message in context: http://www.nabble.com/pgsql2shp-syntax---sentence-construction-tp17613265p17613906.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users