Hi there,
My experience is that it sometimes works better to export the vectors from GRASS as a shapefile and then use shp2pgsql to convert it. I scripted that way of exporting long ago, so I can’t remember exactly the rationale behind it. If I remember correctly, the reason was that some polygons that I tried to export were eliminated from the PostGIS table, but I’m honestly not too sure any more.
If you’re just wanting the table, though, I think db.out.ogr is a good way to go. The command looks good to me, but in your example command, you write “in=” rather than “input=”. Perhaps that’s the problem. Also, does your DB allow write access for every user? Since you have neither username or password, it could be that the database is rejecting your query. If you haven’t tried it yet, give it a shot and let us know how it goes 
Best,
Daniel
–
B.Sc. Daniel Lee
Geschäftsführung für Forschung und Entwicklung
ISIS - International Solar Information Solutions GbR
Vertreten durch: Daniel Lee, Nepomuk Reinhard und Nils Räder
Deutschhausstr. 10
35037 Marburg
Festnetz: +49 6421 379 6256
Mobil: +49 176 6127 7269
E-Mail: Lee@isi-solutions.org
Web: http://www.isi-solutions.org
ISIS wird gefördert durch die Bundesrepublik Deutschland, Zuwendungsgeber: Bundesministerium für Wirtschaft und Technologie aufgrund eines Beschlusses des Deutschen Bundestages, sowie durch die Europäische Union, Zuwendungsgeber: Europäischer Sozialfonds.
Zusätzliche Unterstützung erhält ISIS von dem Entrepreneurship Cluster Mittelhessen, der Universität Marburg, dem Laboratory for Climatology and Remote Sensing und dem GIS-Lab Marburg.
Am 20. März 2012 23:08 schrieb Rich Shepard <rshepard@appl-ecosys.com>:
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
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user