tables

The tables view provides information about all tables and views.

Column name	Data type	Description
table_catalog	sql_identifier	The name of the current database containing the table.
table_schema	sql_identifier	The name of the schema containing the table.
table_name	sql_identifier	The name of the table.
table_type	character_data	The type of the table: The possible options are: BASE TABLE – A persistent base table. VIEW – A view. FOREIGN – A foreign table. LOCAL TEMPORARY – A temporary table.
self_referencing_column_name	sql_identifier	Applies to a feature that is not available in PostgreSQL.
reference_generation	character_data	Applies to a feature that is not available in PostgreSQL.
user_defined_type_catalog	sql_identifier	For a typed table, the name of the current database that contains the underlying data type. NULL – Not a typed table.
user_defined_type_schema	sql_identifier	For a typed table, the name of the schema that contains the underlying data type. NULL – Not a typed table.
user_defined_type_name	sql_identifier	For a typed table, the name of the underlying data type. NULL – Not a typed table.
is_insertable_into	yes_or_no	Specifies whether the table is insertable (YES) or not (NO).
is_typed	yes_or_no	Specifies whether the table is a typed table (YES) or not (NO).
commit_action	character_data	Not yet implemented.