[gdal-dev] Export to Geopackage

[Randal Hale]

If I export a postgis table to geopackage:

ogr2ogr -f GPKG  export.gpkg  PG:"host=gis1 user=rjhale dbname=dbname 
password=pass" -nln "addresspoints" -sql "select id, geom, addresses"

I check the geopackage:

rjhale at gis7:~/temp$ ogrinfo -so -al TCStransport.gpkg

INFO: Open of `TCStransport.gpkg'

       using driver `GPKG' successful.

Layer name: addresspoints

*Geometry: Unknown (any)*

Feature Count: 23735

Any idea on what I'm doing wrong - the unknown geometry seems to be 
causing an issue in another process. If I export without the SQL 
statement everything is fine.

Randy


-- 
--
Randal Hale
rjhale at northrivergeographic.com
https://www.northrivergeographic.com
(423)653-3611

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190314/f773189c/attachment-0001.html>