The pg_tables view provides access to useful information about each table in the database.
Overview
The following table describes the columns in the pg_tables view.
Column | Type | Description |
schemaname | name | Name of schema containing table |
tablename | name | Name of table |
tableowner | name | Name of the table owner |
tablespace | name | Name of tablespace containing table (null if default for database) |
hasindexes | bool | If the table has (or recently had) any indexes, the column is |
hasrules | bool | If the table has (or once had) rules, this column is |
hastriggers | bool | If the table has (or once had) triggers, this column is |
rowsecurity | bool | If row security is enabled on the table, this column is |