Re: [GRASS-user] PostgreSQL not in v.out.ogr format options
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 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 mailto:mlenn...@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 out of range for parameter 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 ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] PostgreSQL not in v.out.ogr format options
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 > 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 >>> mailto:mlenn...@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 out of range for parameter 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 >> > ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] PostgreSQL not in v.out.ogr format options
[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 mailto:mlenn...@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 out of range for parameter 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 ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] PostgreSQL not in v.out.ogr format options
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 out of range for parameter 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 ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user