[GRASSLIST:4147] Re: grass & postgres

[Radim Blazek]

Most probably you use from_database=./ and you are not in
'home/disen/data/grassdata/Upperengadine/disen/dbf/' directory.

But why not directly
v.database driver=pg database="dbname=mydb,user=disen"
v.in.ogr output=siteid_o_s ...

Radim

On Tuesday 10 August 2004 11:29, Daniel Isenegger wrote:
> Hi list,
> i work on grass5.7 and want to use postgres to store attribute tables.
> I have a shapefile (siteid_o_s) imported into Grass and an attribute
> table (siteid_o_s) in postgres.
> Now i try with db.copy to export the shapefile into postgrass
>
> first a test:
> v.db.connect -p map=siteid_o_s
> field <1> table <siteid_o_s> in database
> </home/disen/data/grassdata/Upperengadine/disen/dbf/> through driver
> <dbf> with key <cat>
> seems to work
>
> the command:
> db.copy from_driver=dbf from_database=./ from_table=siteid_o_s
> to_driver=pg to_database="dbname=mydb,user=disen" to_table=siteid_o_p
> D3/3: db_copy_table():
>   from driver = dbf, db = ./, table = siteid_o_s
>   to driver = pg, db = dbname=mydb,user=disen, table = siteid_o_p, where
> = (null)
> D3/3: db_driver_open_database() driver=pg database definition =
> 'dbname=mydb,user=disen'
> D3/3: parse_conn : dbname=mydb,user=disen
> D3/3: token 0 : dbname=mydb
> D3/3: token 1 : user=disen
> D3/3: host = (null), port = (null), options = (null), tty = (null),
> dbname = mydb, user = disen, password = (null)
> D3/3: pgtype = 16,      name = bool ->  type = 16
> D3/3: pgtype = 18,      name = char ->  type = 9
> D3/3: pgtype = 20,      name = int8 ->  type = 3
> D3/3: pgtype = 21,      name = int2 ->  type = 1
> D3/3: pgtype = 23,      name = int4 ->  type = 2
> D3/3: pgtype = 25,      name = text ->  type = 12
> D3/3: pgtype = 26,      name = oid ->   type = 5
> D3/3: pgtype = 700,     name = float4 ->        type = 6
> D3/3: pgtype = 701,     name = float8 ->        type = 7
> D3/3: pgtype = 1042,    name = bpchar ->        type = 10
> D3/3: pgtype = 1043,    name = varchar ->       type = 11
> D3/3: pgtype = 1082,    name = date ->  type = 13
> D3/3: pgtype = 1083,    name = time ->  type = 14
> D3/3: pgtype = 1114,    name = timestamp ->     type = 15
> D3/3: pgtype = 1700,    name = numeric ->       type = 8
> D2/3: pg : BEGIN
> D3/3: select * from siteid_o_s
> D3/3: SQL statement parsed successfully
> D2/3: find_table(): table = siteid_o_s
> DBMI-DBF driver error:
> Table 'siteid_o_s' doesn't exist.
> Error in db_open_select_cursor()
>
> WARNING: Cannot open select cursor: 'select * from siteid_o_s'
> WARNING: Copy table failed
>
> the same error log appears when using
> - not shapefiles, but grass vectors
> - not same name for file and table (in postgres)
>
>
> any ideas what is wrong?
>
> Thanks dani