Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
54.30. pg_tables
Prev UpChapter 54. System ViewsHome Next

54.30. pg_tables

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

Table 54.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
54.29. pg_stats_ext_exprs Home 54.31. pg_timezone_abbrevs
pdfepub
Go to PostgreSQL 15
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp