[GRASS-user] PostgreSQL append

[Pavel Iacovlev]

Good day all,

1.
I have a vector grass file and I want to append it's data to a
PostgreSQL table, atm I use the following command:

v.out.ogr input=flood_vect type=area 'dsn=PG:host=localhost
dbname=gisdb user=gis password=*' olayer=flood layer=1
format=PostgreSQL lco='OVERWRITE=YES'

This command overwrites the postgis table, I want to append the data.
If I remove the lco='OVERWRITE=YES' I just get and error that the
table already exists.

2. When I export vector data to a PostgreSQL table it sets the wrong SRID
> g.region -p
projection: 3 (Latitude-Longitude)
zone:       0
datum:      wgs84
ellipsoid:  wgs84
north:      47:04:48.37738N
south:      46:55:11.265564N
west:       28:44:44.481812E
east:       28:58:20.944519E
nsres:      0:00:02.885559
ewres:      0:00:02.885027
rows:       200
cols:       283
cells:      56600

the SRID of the geometry is 900917, I expect it to be 4326 (wgs84)
what am I doing wrong ?

-- 
http://iap.md, The future is open