I'm writing a quick Python script to bulk export from PosgtreSQL materialized view (PostGIS geometry) to ESRI FileGDB and ogr2ogr (I'm using the one in OSGeo4W through Python subprocess module) is throwing an error
ERROR 1: ERROR: relation "my_schema_name.my_TABLE_name" does not exist
The name is just an example. I want to underline that the view has upper letters, but I'm passing the argument double quoted like this
table_name = '"my_schema_name.my_TABLE_name"'. Is that correct?
I have no problem exporting from normal tables that the view is based on.
Does ogr2ogr read materialized view at all?