Opened 12 years ago
Closed 12 years ago
#4309 closed defect (worksforme)
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 (2)
comment:1 by , 12 years ago
comment:2 by , 12 years ago
| Resolution: | → worksforme |
|---|---|
| Status: | new → closed |
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.
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.