[GRASSLIST:4960] Re: v.database

[Radim Blazek]

Leonardo Lami wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Alle 17:39, mercoledì 24 novembre 2004, hai scritto:
> 
>>Leonardo Lami wrote:
>>
>>>I think there is no problem if you remove v.database.
>>>I do not remember if you resolved the problem about v.db.connect and
>>>schema. I think that there is problem to connect a vector with a table in
>>>a schema with v.db.connect.
>>
>>Cannot you simply use table=myschema.mytable ?
>>
>>
>>Radim
> 
> 
> Hi Radim,
> If I use this option with v.database or db.connect I have no problem but if I 
> use it with v.db.connect I have this ouutput message:
> 
> v.db.connect map=sir_clump driver=pg 
> database=host=192.168.0.10,dbname=faunalia,user=username,password=###### 
> table=prova.anfibi key=cat field=1 
> ERROR: Table <prova.anfibi> does not exist in database
>        <host=192.168.0.10,dbname=faunalia,user=username,password=######>

For now, I just changed error to warning, so that it should give you 
error but it should connect the table.

I dont have postgres with schemas and I am not sure how some
functions should work, for example db_list_tables/db.tables
should return all tables in schema.table form?


Radim