336247 (1) [Avatar] Offline
#1
ogr2ogr -f "KML" /gisdata/biketrip.kml 
PG:"host=localhost user=postgres port=5432  dbname=postgis_in_action password=mypassword" -dsco NameField=time 
-select "SELECT track_seg_point_id, ele, time"
-where "time BETWEEN '2009-07-18 04:33-04' AND '2009-07-18 04:34-04'" staging.aus_biketrip_narangba


I had to remove "SELECT" (not "-select") in order to make this work, otherwise it complains that "Field 'SELECT' not found in source layer."
regina.leo (257) [Avatar] Offline
#2
Thanks. We'll note in the errata