I have some rasters in PostGIS and I want to open just those which match to where clause. How can I do that? I have tried:
ds = gdal.Open("PG:host=<host> dbname=<dbname> table=<tablename> user=<user> password=<psswd> where='observ_date=\'2015-06-26\'::date'")
and some other combinations of quotes, but with no success. Everytime I got an error like this
ERROR 1: Error browsing database for PostGIS Raster properties : ERROR: cannot cast type integer to date LINE 1: ...r.alaska_mod13q1_ndvi where observ_date=2015-06-26::date gro...
It means that wrote quotes wrong. So how should I write quotes in where clause in PG connection string correctly?