<div class="gmail_quote"><div class="gmail_quote">2011/11/24 Micha Silver <span dir="ltr"><<a href="mailto:micha@arava.co.il">micha@arava.co.il</a>></span><br><blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; ">
<div text="#000000" bgcolor="#ffffff" style="direction: ltr; ">There are two separate metadata tables in newer PostGIS versions. The original geometry_columns is a real table as listed above. In addition there is support for the geography data type for layers in geographic (Lat/Lon) coordinate systems. With the geography type comes a new set of metadata, geography_columns. But this is indeed a view, not a real table. You'll see it with :<br>
geodata=# \dv</div></blockquote></div>Gotcha, you're right there. I hadn't seen it.</div><div class="gmail_quote"><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div style="direction:ltr" text="#000000" bgcolor="#ffffff">The question remains why are you getting this error? <br>
Does the table perhaps already exist in your PostGIS database from
the previous failed exports?</div></blockquote></div>No, it hadn't. But now I've made a new template with a new database, I'm hoping for more success.<div><br></div><div>2011/11/25 Moritz Lennert <span dir="ltr"><<a href="mailto:mlennert@club.worldonline.be">mlennert@club.worldonline.be</a>></span><br>
<blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; ">
<div id=":3c">The single quotes are not positioned correctly here. It should be:<div class="im"><br><br>v.out.ogr in=Gebaeude_Globalstrahlung dsn='PG:host=localhost dbname=test user=lee password=XXX' type=area format=PostgreSQL<br>
<br></div>BTW: your single quotes look like backticks. That might also cause problems. Are you working on the command line or in a GUI ?</div></blockquote><div>That's right with the quotes. I think I'd put together the command in the GUI and then tried pasting it into the command line, maybe that's how the backticks got in there. I'd already tried it with the quotes in the right place, but perhaps I had a problem because they were backticks. </div>
<div><br></div><div>2011/11/25 Pankaj Kr Sharma <span dir="ltr"><<a href="mailto:pkscwc@gmail.com">pkscwc@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; ">
<div id=":ax">Try to find the owner of your geography tables.<br>Most probably, it will be "postgres".<br>So, login as "postgres" and from their grant all on geography tables to the desired owner.</div>
</blockquote><div>Great tip. I did try that in the old version, but it didn't make a difference. In the new template that I made before I copied it for the current database I'm trying to work in I set GRANT ALL on all tables to public, which is the schema my user's in, I think.</div>
</div><div><br></div><div>2011/11/25 Richard Chirgwin <span dir="ltr"><<a href="mailto:rchirgwin@ozemail.com.au">rchirgwin@ozemail.com.au</a>></span><br><blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; ">
<div id=":eb">Database permissions in Grass-GIS are stored by mapset - you can only have one set of database parameters stored for one mapset. Moving data between database types is simplest and most reliable if you use different mapsets for different databases.<br>
<br>Hence: if you've created maps with DBF permissions, I suggest:<br><br>1. create new mapset, and enter Grass-GIS in the new mapset.<br>2. set database connection for new mapset using db.connect and db.login<br>3. use g.copy vect=map@oldmapset,map (running in the target mapset)<br>
<br>This will create the tables in the target mapset, linked to maps in the target.<br><br>Note that you have to present the right credentials to PostGIS - owner and password.</div></blockquote><div>I think this'll be the best way for me. I can reproject everything while I'm at it, too. I've now made a separate location and am going to do everything from there.</div>
</div><div>That should mean that I connect the mapset to the database and when I import stuff into that mapset it's automatically imported into the database? Then I'm basically working on the vectors, etc. IN my PostGIS database? That would be nice.</div>
<div><br></div><div>Thanks for all the help! I'll report back in a few minutes as soon as I've given it a try.</div><div> </div></div>