PG_TABLES

PG_TABLES is used to query useful information about each table in a database. For details about the columns, see Table 1.

**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	Whether the table has (or recently had) an index. If it does, the value is true. Otherwise, the value is false.
hasrules	boolean	PG_CLASS.relhasruls	Whether the table has rules. If it does, the value is true. 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(PG_OBJECT.creator)	Table owner
created	timestamp with time zone	PG_OBJECT.ctime	Time when the table is created.
last_ddl_time	timestamp with time zone	PG_OBJECT.mtime	Time when the last DDL operation is performed on a table.

Parent topic: Other System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.