Opened 11 years ago

Closed 11 years ago

Last modified 11 years ago

#4788 closed enhancement (fixed)

PostgreSQL Output driver does not support hstore columns

Reported by: giggls Owned by: Even Rouault
Priority: low Milestone: 1.10.0
Component: OGR_SF Version:
Severity: normal Keywords: pg hstore


With the new Openstreetmap Input driver ogr just became a handy utility for converting OSM data to postgresql.

With the free tagging scheme of OSM it would be very handy to store any keys from OSM without their own column in a psql hstore field rather than "character varying".

Change History (5)

comment:1 by Even Rouault, 11 years ago

Owner: changed from warmerdam to Even Rouault

comment:2 by Even Rouault, 11 years ago

Component: defaultOGR_SF
Keywords: pg added
Milestone: 2.0.0
Resolution: fixed
Status: newclosed

r24826: "PG: add a 'HSTORE_COLUMNS' layer creation option (#4788)"

r24827: "OSM: follow the quoting rules for HSTORE content"

Example :

ogr2ogr -f PostgreSQL "PG:dbname=osm" test.pbf -lco HSTORE_COLUMNS=other_tags

comment:3 by Even Rouault, 11 years ago

r25364: "PGDUMP: add a 'HSTORE_COLUMNS' layer creation option (#4788)"

comment:4 by Even Rouault, 11 years ago

r25366 : "PG and PGDump: remove HSTORE_COLUMNS layer creation option and replace it by a more general COLUMN_TYPES option (#4788)"

comment:5 by Even Rouault, 11 years ago

r25368: "PG: Test COLUMN_TYPES layer creation option (#4788)"

Note: See TracTickets for help on using tickets.