Ticket #4309 (closed defect: worksforme)

Opened 19 months ago

Last modified 19 months ago

PGDump driver always dumps all columns (ignores -sql option)

Reported by: jlivni Owned by: warmerdam
Priority: normal Milestone:
Component: default Version: unspecified
Severity: normal Keywords: pgdump, ogr2ogr
Cc: jlivni

Description

This works as expected (CSV with only the foo column): ogr2ogr -f CSV -sql "select foo from bar" test.csv bar.shp

This does not work as expected (SQL dump includes all columns):

ogr2ogr -f PGDump -sql "select foo from bar" test.sql bar.shp

Change History

Changed 19 months ago by rouault

I can't reproduce your issue with latest trunk or 1.8.0. I can't imagine how this could not work. What is your GDAL version ? Are you really sure that you have used the command line you mention ? Please paste the real one. This might be something with the real SQL clause you have used, perhaps a quoting error.

Changed 19 months ago by rouault

  • status changed from new to closed
  • resolution set to worksforme

Closing as "works for me". Reopen if you can provide more detailed elements on how to reproduce

Note: See TracTickets for help on using tickets.