[GRASS-user] PostgreSQL not in v.out.ogr format options

GRASS GRASS user
, ,
1

All,

Using GRASS7. I would like to write to postgis from a GRASS vector file, and would like to be able to append to a table as opposed to create new. I see that the -a flag is not implemented yet in v.out.postgis so I turned to v.out.ogr. Despite having a fully functional GDAL with the OGR PostgreSQL driver installed and functional, when I pass the following command:

v.out.ogr -a -m --verbose input=t_lands type=area output="PG:dbname=cf_tribal" output_layer=foo format=PostgreSQL

the response is:

ERROR: Value <PostgreSQL> out of range for parameter <format> Legal range: BNA,CSV,CartoDB,Cloudant,CouchDB,DGN,DXF,ESRI_Shapefile,ElasticSearch,GFT,GME,GML,GPKG,GPSBabel,GPSTrackMaker,GPX,GeoJSON,GeoRSS,Geoconcept,JML,KML,MapInfo_File,Memory,ODS,OGR_GMT,PCIDSK,PDF,PGDUMP,S57,SQLite,Selafin,TIGER,WAsP,XLSX

Thanks in advance for any suggestions.

Peter

2

On 29/04/16 18:00, Peter Tittmann wrote:

All,

Using GRASS7. I would like to write to postgis from a GRASS vector file,
and would like to be able to append to a table as opposed to create new.
I see that the `-a` flag is not implemented yet in v.out.postgis so I
turned to v.out.ogr. Despite having a fully functional GDAL with the OGR
PostgreSQL driver installed and functional, when I pass the following
command:

`v.out.ogr -a -m --verbose input=t_lands type=area
output="PG:dbname=cf_tribal" output_layer=foo format=PostgreSQL`

  the response is:

`ERROR: Value <PostgreSQL> out of range for parameter <format>
Legal range:
BNA,CSV,CartoDB,Cloudant,CouchDB,DGN,DXF,ESRI_Shapefile,ElasticSearch,GFT,GME,GML,GPKG,GPSBabel,GPSTrackMaker,GPX,GeoJSON,GeoRSS,Geoconcept,JML,KML,MapInfo_File,Memory,ODS,OGR_GMT,PCIDSK,PDF,PGDUMP,S57,SQLite,Selafin,TIGER,WAsP,XLSX`

What does

ogrinfo --formats | grep PostgreSQL

give you ?

Moritz

3

[Please keep discussions on the list]

On 29/04/16 19:35, Peter Tittmann wrote:

Thx for your reply!

   -> "PostgreSQL" (read/write)

And

v.in.ogr -f | grep PostgreSQL

?

If that doesn't show success, then it would seem to me that there might be an issue in your installation with GRASS not picking up the correct ogr libraries.

On what OS are you ?

Moritz

On Apr 29, 2016, at 10:27 AM, Moritz Lennert
<mlennert@club.worldonline.be <mailto:mlennert@club.worldonline.be>>
wrote:

On 29/04/16 18:00, Peter Tittmann wrote:

All,

Using GRASS7. I would like to write to postgis from a GRASS vector file,
and would like to be able to append to a table as opposed to create new.
I see that the `-a` flag is not implemented yet in v.out.postgis so I
turned to v.out.ogr. Despite having a fully functional GDAL with the OGR
PostgreSQL driver installed and functional, when I pass the following
command:

`v.out.ogr -a -m --verbose input=t_lands type=area
output="PG:dbname=cf_tribal" output_layer=foo format=PostgreSQL`

the response is:

`ERROR: Value <PostgreSQL> out of range for parameter <format>
Legal range:
BNA,CSV,CartoDB,Cloudant,CouchDB,DGN,DXF,ESRI_Shapefile,ElasticSearch,GFT,GME,GML,GPKG,GPSBabel,GPSTrackMaker,GPX,GeoJSON,GeoRSS,Geoconcept,JML,KML,MapInfo_File,Memory,ODS,OGR_GMT,PCIDSK,PDF,PGDUMP,S57,SQLite,Selafin,TIGER,WAsP,XLSX`

What does

ogrinfo --formats | grep PostgreSQL

give you ?

Moritz

4

Moritz,

I am on OS X and have installed gala and grass using home-brew.

v.in.ogr -f results do not include PostgreSQL

Any suggestions?

Sorry for the delay getting back…

Peter

On Apr 30, 2016, at 5:55 AM, Moritz Lennert <mlennert@club.worldonline.be> wrote:

[Please keep discussions on the list]

On 29/04/16 19:35, Peter Tittmann wrote:

Thx for your reply!

  -> "PostgreSQL" (read/write)

And

v.in.ogr -f | grep PostgreSQL

?

If that doesn't show success, then it would seem to me that there might be an issue in your installation with GRASS not picking up the correct ogr libraries.

On what OS are you ?

Moritz

On Apr 29, 2016, at 10:27 AM, Moritz Lennert
<mlennert@club.worldonline.be <mailto:mlennert@club.worldonline.be>>
wrote:

On 29/04/16 18:00, Peter Tittmann wrote:

All,

Using GRASS7. I would like to write to postgis from a GRASS vector file,
and would like to be able to append to a table as opposed to create new.
I see that the `-a` flag is not implemented yet in v.out.postgis so I
turned to v.out.ogr. Despite having a fully functional GDAL with the OGR
PostgreSQL driver installed and functional, when I pass the following
command:

`v.out.ogr -a -m --verbose input=t_lands type=area
output="PG:dbname=cf_tribal" output_layer=foo format=PostgreSQL`

the response is:

`ERROR: Value <PostgreSQL> out of range for parameter <format>
Legal range:
BNA,CSV,CartoDB,Cloudant,CouchDB,DGN,DXF,ESRI_Shapefile,ElasticSearch,GFT,GME,GML,GPKG,GPSBabel,GPSTrackMaker,GPX,GeoJSON,GeoRSS,Geoconcept,JML,KML,MapInfo_File,Memory,ODS,OGR_GMT,PCIDSK,PDF,PGDUMP,S57,SQLite,Selafin,TIGER,WAsP,XLSX`

What does

ogrinfo --formats | grep PostgreSQL

give you ?

Moritz

5

On 11/05/16 20:55, Peter Tittmann wrote:

Moritz,

I am on OS X and have installed gala and grass using home-brew.

v.in.ogr -f results do not include PostgreSQL

Any suggestions?

Sounds like GRASS is using a different gdal installation than ogr2ogr...

I am no expert on Mac installation, so others will have to help you with this.

Rainer, do you have any advice ?

Moritz

Sorry for the delay getting back…

Peter

On Apr 30, 2016, at 5:55 AM, Moritz Lennert <mlennert@club.worldonline.be> wrote:

[Please keep discussions on the list]

On 29/04/16 19:35, Peter Tittmann wrote:

Thx for your reply!

   -> "PostgreSQL" (read/write)

And

v.in.ogr -f | grep PostgreSQL

?

If that doesn't show success, then it would seem to me that there might be an issue in your installation with GRASS not picking up the correct ogr libraries.

On what OS are you ?

Moritz

On Apr 29, 2016, at 10:27 AM, Moritz Lennert
<mlennert@club.worldonline.be <mailto:mlennert@club.worldonline.be>>
wrote:

On 29/04/16 18:00, Peter Tittmann wrote:

All,

Using GRASS7. I would like to write to postgis from a GRASS vector file,
and would like to be able to append to a table as opposed to create new.
I see that the `-a` flag is not implemented yet in v.out.postgis so I
turned to v.out.ogr. Despite having a fully functional GDAL with the OGR
PostgreSQL driver installed and functional, when I pass the following
command:

`v.out.ogr -a -m --verbose input=t_lands type=area
output="PG:dbname=cf_tribal" output_layer=foo format=PostgreSQL`

the response is:

`ERROR: Value <PostgreSQL> out of range for parameter <format>
Legal range:
BNA,CSV,CartoDB,Cloudant,CouchDB,DGN,DXF,ESRI_Shapefile,ElasticSearch,GFT,GME,GML,GPKG,GPSBabel,GPSTrackMaker,GPX,GeoJSON,GeoRSS,Geoconcept,JML,KML,MapInfo_File,Memory,ODS,OGR_GMT,PCIDSK,PDF,PGDUMP,S57,SQLite,Selafin,TIGER,WAsP,XLSX`

What does

ogrinfo --formats | grep PostgreSQL

give you ?

Moritz