[GRASS-user] db.out.ogr Clarification

Rich Shepard rshepard at appl-ecosys.com
Tue Mar 20 18:08:42 EDT 2012


   I want to transfer vector map attribute data from the default dbf to a
postgres table. Reading the db.out.ogr manual page suggests that it will
output the attribute table from the existing dbf to a postgres table, but
the example does not appear to match the command syntax, and I don't get the
difference between the input table name and the DSN name.

   The command is:
db.out.ogr input=name dsn=name format=string [db_table=name] [--verbose]
[--quiet]

   Looking at the example I see:

db.out.ogr precip_30ynormals dsn="PG:host=localhost dbname=meteo
user=neteler" format=PostgreSQL
echo "SELECT * FROM precip_30ynormals" | psql meteo

   If I want to move the attributes of the 'stream' table would the command
be:

db.out.ogr in=stream dsn="PG:host=localhost dbname=washington" \
format=PostgreSQL

echo "SELECT * FROM streams" | psql washington

Rich




More information about the grass-user mailing list