Hi there,<br><br>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. <br>
<br>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 ;)<br>
<br>Best,<br>Daniel<br clear="all">
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"></span></p><p>--<br></p><p>B.Sc. Daniel Lee<br>
Geschäftsführung für Forschung und Entwicklung<br>ISIS - International Solar Information Solutions GbR<br>Vertreten durch: Daniel Lee, Nepomuk Reinhard und Nils Räder<br></p><p>Deutschhausstr. 10<br>35037 Marburg<br>Festnetz: <a value="+4964213796256" style="color:rgb(28,81,168)">+49 6421 379 6256</a><br>
Mobil: <a value="+4917661277269" style="color:rgb(28,81,168)">+49 176 6127 7269</a><br>E-Mail: <a href="mailto:Lee@isi-solutions.org" style="color:rgb(28,81,168)" target="_blank">Lee@isi-solutions.org</a><br>Web: <a href="http://www.isi-solutions.org/" style="color:rgb(28,81,168)" target="_blank">http://www.isi-solutions.org</a></p>
<p>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.<br>
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.</p><p></p><br>
<br><br><div class="gmail_quote">Am 20. März 2012 23:08 schrieb Rich Shepard <span dir="ltr"><<a href="mailto:rshepard@appl-ecosys.com">rshepard@appl-ecosys.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I want to transfer vector map attribute data from the default dbf to a<br>
postgres table. Reading the db.out.ogr manual page suggests that it will<br>
output the attribute table from the existing dbf to a postgres table, but<br>
the example does not appear to match the command syntax, and I don't get the<br>
difference between the input table name and the DSN name.<br>
<br>
The command is:<br>
db.out.ogr input=name dsn=name format=string [db_table=name] [--verbose]<br>
[--quiet]<br>
<br>
Looking at the example I see:<br>
<br>
db.out.ogr precip_30ynormals dsn="PG:host=localhost dbname=meteo<br>
user=neteler" format=PostgreSQL<br>
echo "SELECT * FROM precip_30ynormals" | psql meteo<br>
<br>
If I want to move the attributes of the 'stream' table would the command<br>
be:<br>
<br>
db.out.ogr in=stream dsn="PG:host=localhost dbname=washington" \<br>
format=PostgreSQL<br>
<br>
echo "SELECT * FROM streams" | psql washington<br>
<br>
Rich<br>
<br>
<br>
______________________________<u></u>_________________<br>
grass-user mailing list<br>
<a href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/grass-user</a><br>
</blockquote></div><br>