Needed a 'schema' option when configuring a foreign table when the remote database(Postgres) organized its tables into schemas. If tables are not qualified with the schema name they cannot be accessed if they are under a schema and it did not appear possible to specify a default schema via the db_url. Hopefully this or a similar schema option can be added.
Needed a 'schema' option when configuring a foreign table when the remote database(Postgres) organized its tables into schemas. If tables are not qualified with the schema name they cannot be accessed if they are under a schema and it did not appear possible to specify a default schema via the db_url. Hopefully this or a similar schema option can be added.