| PostgreSQL 8.0.1 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 30. The Information Schema | Fast Forward | Next |
30.36. tables
The view tables contains all tables and views defined in the current database. Only those tables and views are shown that the current user has access to (by way of being the owner or having some privilege).
Table 30-34. tables Columns
| Name | Data Type | Description |
|---|---|---|
| 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 |
