PostgreSQL — SQLAlchemy 1.4 Documentation
docs.sqlalchemy.org › en › latestThe PostgreSQL dialect can reflect tables from any schema, as outlined in schema_table_reflection. With regards to tables which these Table objects refer to via foreign key constraint, a decision must be made as to how the .schema is represented in those remote tables, in the case where that remote schema name is also a member of the current PostgreSQL search path.