Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
52.30. pg_tables
Prev UpChapter 52. System ViewsHome Next

52.30. pg_tables#

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

Table 52.30. pg_tables Columns

Column Type

Description

schemanamename (referencespg_namespace.nspname)

Name of schema containing table

tablenamename (referencespg_class.relname)

Name of table

tableownername (referencespg_authid.rolname)

Name of table's owner

tablespacename (referencespg_tablespace.spcname)

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

hasindexesbool (referencespg_class.relhasindex)

True if table has (or recently had) any indexes

hasrulesbool (referencespg_class.relhasrules)

True if table has (or once had) rules

hastriggersbool (referencespg_class.relhastriggers)

True if table has (or once had) triggers

rowsecuritybool (referencespg_class.relrowsecurity)

True if row security is enabled on the table



Prev Up Next
52.29. pg_stats_ext_exprs Home 52.31. pg_timezone_abbrevs
pdfepub
Go to PostgreSQL 17
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp