| table_catalog | sql_identifier | Name of the database that contains the table (always the current database) |
| table_schema | sql_identifier | Name of the schema that contains the table |
| table_name | sql_identifier | Name of the table |
| table_type | character_data | Type of the table: BASE TABLE for a
persistent base table (the normal table type),
VIEW for a view, or LOCAL
TEMPORARY for a temporary table
|
| self_referencing_column_name | sql_identifier | Applies to a feature not available in PostgreSQL |
| reference_generation | character_data | Applies to a feature not available in PostgreSQL |
| user_defined_type_catalog | sql_identifier | Applies to a feature not available in PostgreSQL |
| user_defined_type_schema | sql_identifier | Applies to a feature not available in PostgreSQL |
| user_defined_type_name | sql_identifier | Applies to a feature not available in PostgreSQL |
| is_insertable_into | character_data | YES if the table is insertable into,
NO if not (Base tables are always insertable
into, views not necessarily.)
|
| is_typed | character_data | Applies to a feature not available in PostgreSQL |
| commit_action | character_data | If the table is a temporary table, then
PRESERVE, else null. (The SQL standard
defines other commit actions for temporary tables, which are
not supported by PostgreSQL.)
|