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

[Peter Tittmann]

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 at 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 at club.worldonline.be <mailto:mlennert at 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
>> 
>