sqlalchemy.databases.postgresql.PGInspector

Method	`get_enums`	Return a list of ENUM objects.
Method	`get_foreign_table_names`	Return a list of FOREIGN TABLE names.
Method	`get_table_oid`	Return the OID for the given table name.
Method	`get_view_names`	Return all view names in `schema`.

Inherited from Inspector:

Class Method	`from_engine`	Construct a new dialect-specific Inspector object from the given engine or connection.
Method	`__init__`	Initialize a new `_reflection.Inspector`.
Method	`get_check_constraints`	Return information about check constraints in `table_name`.
Method	`get_columns`	Return information about columns in `table_name`.
Method	`get_foreign_keys`	Return information about foreign_keys in `table_name`.
Method	`get_indexes`	Return information about indexes in `table_name`.
Method	`get_pk_constraint`	Return information about primary key constraint on `table_name`.
Method	`get_schema_names`	Return all schema names.
Method	`get_sequence_names`	Return all sequence names in `schema`.
Method	`get_sorted_table_and_fkc_names`	Return dependency-sorted table and foreign key constraint names in referred to within a particular schema.
Method	`get_table_comment`	Return information about the table comment for `table_name`.
Method	`get_table_names`	Return all table names in referred to within a particular schema.
Method	`get_table_options`	Return a dictionary of options specified when the table of the given name was created.
Method	`get_temp_table_names`	Return a list of temporary table names for the current bind.
Method	`get_temp_view_names`	Return a list of temporary view names for the current bind.
Method	`get_unique_constraints`	Return information about unique constraints in `table_name`.
Method	`get_view_definition`	Return definition for `view_name`.
Method	`has_sequence`	Return True if the backend has a table of the given name.
Method	`has_table`	Return True if the backend has a table of the given name.
Method	`reflect_table`	Given a `_schema.Table` object, load its internal constructs based on introspection.
Method	`reflecttable`	See reflect_table. This method name is deprecated
Class Method	`_construct`	Undocumented
Method	`_connectable_insp`	Undocumented
Method	`_connection_insp`	Undocumented
Method	`_engine_insp`	Undocumented
Method	`_init_connection`	Undocumented
Method	`_init_engine`	Undocumented
Method	`_init_legacy`	Undocumented
Method	`_inspection_context`	Return an `_reflection.Inspector` from this one that will run all operations on a single connection.
Method	`_operation_context`	Return a context that optimizes for multiple operations on a single transaction.
Method	`_reflect_check_constraints`	Undocumented
Method	`_reflect_col_sequence`	Undocumented
Method	`_reflect_column`	Undocumented
Method	`_reflect_fk`	Undocumented
Method	`_reflect_indexes`	Undocumented
Method	`_reflect_pk`	Undocumented
Method	`_reflect_table_comment`	Undocumented
Method	`_reflect_unique_constraints`	Undocumented
Class Variable	`_index_sort_exprs`	Undocumented
Instance Variable	`_op_context_requires_connect`	Undocumented
Instance Variable	`bind`	Undocumented
Instance Variable	`dialect`	Undocumented
Instance Variable	`engine`	Undocumented
Instance Variable	`info_cache`	Undocumented
Property	`default_schema_name`	Return the default schema name presented by the dialect for the current engine's database user.

def get_enums(self, schema=None):

Return a list of ENUM objects.

Each member is a dictionary containing these fields:

name - name of the enum

schema - the schema name for the enum.

visible - boolean, whether or not this enum is visible in the default search path.

labels - a list of string labels that apply to the enum.

New in version 1.0.0.

Parameters
schema	schema name. If None, the default schema (typically 'public') is used. May also be set to '*' to indicate load enums for all schemas.

def get_foreign_table_names(self, schema=None):

Return a list of FOREIGN TABLE names.

Behavior is similar to that of _reflection.Inspector.get_table_names, except that the list is limited to those tables that report a relkind value of f.

New in version 1.0.0.

def get_table_oid(self, table_name, schema=None):

Return the OID for the given table name.

def get_view_names(self, schema=None, include=('plain', 'materialized')):

overrides sqlalchemy.engine.reflection.Inspector.get_view_names

Return all view names in schema.

Parameters
schema	Optional, retrieve names from a non-default schema. For special quoting, use `.quoted_name`.
include	specify which types of views to return. Passed as a string value (for a single type) or a tuple (for any number of types). Defaults to `('plain', 'materialized')`. New in version 1.1.