[GRASS-user] Joining vectors by location

[Moritz Lennert]

On 24/11/11 17:18, Daniel Lee wrote:
>     IIRC, geography_columns is a view, not sure why you would even want
>     to access that...
>
>     I don't have time right now to try to find out where the error
>     message comes from. Can you give us the exact v.in.ogr command you use ?
>
> Gotcha. I think it is a table, actually:
>
>     test=# \dt
>                   List of relations
>       Schema |       Name       | Type  | Owner
>     --------+------------------+-------+-------
>       public | geometry_columns | table | lee
>       public | spatial_ref_sys  | table | lee
>     (2 rows)
>
> This is my test DB that I'm using to kind of experiment and those are
> the two tables that were produced as I was setting up the PostGIS DB.
> Nonetheless, I don't necessarily want to access those tables, I just
> want to upload my vectors. This is the v.out.ogr command I used:
> v.out.ogr in=Gebaeude_Globalstrahlung dsn=’PG:host=localhost dbname=test
> user=lee password=XXX type=area format=PostgreSQL’

The single quotes are not positioned correctly here. It should be:

v.out.ogr in=Gebaeude_Globalstrahlung dsn='PG:host=localhost dbname=test 
user=lee password=XXX' type=area format=PostgreSQL

BTW: your single quotes look like backticks. That might also cause 
problems. Are you working on the command line or in a GUI ?

Moritz