Is it possible to read Postgres information_schema...
# ask-ai
m
Is it possible to read Postgres information_schema tables and views in the postgres source connector?
u
Based on the provided knowledge sources, there is no explicit information about reading Postgres information_schema tables and views using the Airbyte Postgres source connector. However, I can provide some relevant information about views and schema selection in the Postgres connector: 1. There have been issues with reading views in older versions of the Postgres source connector. Several forum posts and GitHub issues mention problems with discovering or syncing views [Source Postgres Not Possible Select Views](https://discuss.airbyte.io/t/245), [Cant Fetch postgredb views in schema discovery](https://discuss.airbyte.io/t/940), [Failure to discover streams from Postgres source](https://discuss.airbyte.io/t/930). 2. These issues were reportedly fixed in version 0.4.14 of the Postgres source connector, as mentioned in a support response: "Can you test the new version 0.4.14? [馃帀 Source postgres: publish fix of missing streams by tuliren 路 Pull Request #12689 路 airbytehq/airbyte 路 GitHub](https://github.com/airbytehq/airbyte/pull/12689) PR solves the issue" [Failure to discover streams from Postgres source](https://discuss.airbyte.io/t/930). 3. Regarding schema selection, as of the time the knowledge sources were created, it was not possible to specify a particular schema when connecting to Postgres as a source. A support user stated: "It's not possible right now, you can specify the database name and select the tables you want to sync to your destination." [Source Postgres: select specific schema to sync](https://discuss.airbyte.io/t/105). Given this information, it's unclear whether the Postgres source connector can specifically read information_schema tables and views. To get a definitive answer, you may need to: 1. Ensure you're using the latest version of the Postgres source connector. 2. Try setting up a connection and see if the information_schema tables and views appear in the available streams. 3. If they don't appear, you might need to reach out to Airbyte support for more specific guidance on this use case.