PostgreSQL
54.30. pg_tables
The view pg_tables
provides access to useful information about each table in the database.
Table 54.30. pg_tables
Columns
Column Type Description |
---|
Name of schema containing table |
Name of table |
Name of table’s owner |
Name of tablespace containing table (null if default for database) |
True if table has (or recently had) any indexes |
True if table has (or once had) rules |
True if table has (or once had) triggers |
True if row security is enabled on the table |
+
Prev | Up | Next |
---|---|---|
54.29. |
54.31. |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group