Are you an LLM? You can read better optimized documentation at /en/docs/latest/database_reference/pg_tables.md for this page in Markdown format
PG_TABLES
PG_TABLES provides access to each table in the database.
Table 1 PG_TABLES columns
Name | Type | Reference | Description |
|---|
schemaname | name | PG_NAMESPACE.nspname | Name of the schema that contains a table |
tablename | name | PG_CLASS.relname | Table name |
tableowner | name | pg_get_userbyid(PG_CLASS.relowner) | Table owner |
tablespace | name | PG_TABLESPACE.spcname | Tablespace that contains the table (default value: null) |
hasindexes | Boolean | PG_CLASS.relhasindex | The value is true if the table has (or recently had) an index; otherwise, the value is false. |
hasrules | Boolean | PG_CLASS.relhasruls | The value is true if the table has rules; otherwise, the value is false. |
hastriggers | Boolean | PG_CLASS.RELHASTRIGGERS | The value is TRUE if the table has triggers; otherwise, the value is FALSE. |
tablecreator | name | pg_get_userbyid(po.creator) | Table creator. |
created | timestamp with time zone | pg_object.ctime | Creation time of the object |
last_ddl_time | timestamp with time zone | pg_object.mtime | Last modification time of the object |