Why Doesn't the \dt Command List Fivetran Tables?

Question

Why doesn't the \dt command list Fivetran tables in my PostgreSQL destination?

Environment

All PostgreSQL destinations

Answer

The \dt command in PostgreSQL only lists tables in the current search path, which defaults to the public schema unless explicitly modified. However, we organize tables into connector-specific schemas which are not included in the default search path. As a result, the \dt command doesn't list these tables.

To see Fivetran tables, do the following:

1. Use the \dn command to list all applicable database schemas.
2. Identify schemas with names in the format <connector_name>_<schema_name>.
3. Use the \dt <connector_name>_<schema_name>.* command to list the tables within a specific schema, replacing <connector_name>_<schema_name> with the schema name.