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

[Moritz Lennert]

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 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
>>>
>>
>