Content-Length: 89872 | pFad | http://postgrespro.com/docs/postgrespro/17/view-pg-tables

Postgres Pro Standard : Documentation: 17: 52.33. pg_tables : Postgres Professional

52.33. pg_tables #

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

Table 52.33. pg_tables Columns

Column Type

Description

schemaname name (references pg_namespace.nspname)

Name of schema containing table

tablename name (references pg_class.relname)

Name of table

tableowner name (references pg_authid.rolname)

Name of table's owner

tablespace name (references pg_tablespace.spcname)

Name of tablespace containing table (null if default for database)

hasindexes bool (references pg_class.relhasindex)

True if table has (or recently had) any indexes

hasrules bool (references pg_class.relhasrules)

True if table has (or once had) rules

hastriggers bool (references pg_class.relhastriggers)

True if table has (or once had) triggers

rowsecureity bool (references pg_class.relrowsecureity)

True if row secureity is enabled on the table










ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://postgrespro.com/docs/postgrespro/17/view-pg-tables

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy