pg_tables

The view pg_tables provides access to useful information about each table in the database.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

kind: view
lang: en
measured attributes: true
metadata release: 18.6
runtime columns: schemaname, tablename, tableowner, tablespace, hasindexes, hasrules, hastriggers, rowsecurity
runtime verified: false
source: english-manual

Definition PG 18

The view pg_tables provides access to useful information about each table in the database.

Column	Type	Nullability	Description
schemaname	name	Nullable	Name of schema containing table
tablename	name	Nullable	Name of table
tableowner	name	Nullable	Name of table's owner
tablespace	name	Nullable	Name of tablespace containing table (null if default for database)
hasindexes	bool	Nullable	True if table has (or recently had) any indexes
hasrules	bool	Nullable	True if table has (or once had) rules
hastriggers	bool	Nullable	True if table has (or once had) triggers
rowsecurity	bool	Nullable	True if row security is enabled on the table

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:4d3fa722852a74a4cb4baa3e386435ea8b242dcd30c160802204b1969c570ead

Text language: en · catalog-bilingual-repair:4d3fa722852a74a4cb4baa3e386435ea8b242dcd30c160802204b1969c570ead