This page lists the PostgreSQL system catalog views that Spanner supports.
pg_available_extension_versions
The pg_available_extension_versions
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
name
|
text
|
N |
version
|
text
|
N |
installed
|
bool
|
N |
superuser
|
bool
|
N |
trusted
|
bool
|
N |
relocatable
|
bool
|
N |
schema
|
text
|
N |
requires
|
text[]
|
N |
comment
|
text
|
N |
pg_available_extensions
The pg_available_extensions
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
name
|
text
|
N |
default_version
|
text
|
N |
installed_version
|
text
|
N |
comment
|
text
|
N |
pg_config
The pg_config
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
name
|
text
|
N |
setting
|
text
|
N |
pg_cursors
The pg_cursors
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
name
|
text
|
N |
statement
|
text
|
N |
is_holdable
|
bool
|
N |
is_binary
|
bool
|
N |
is_scrollable
|
bool
|
N |
creation_time
|
timestamptz
|
N |
pg_file_settings
The pg_file_settings
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
sourcefile
|
text
|
N |
sourceline
|
int8
|
N |
seqno
|
int8
|
N |
name
|
text
|
N |
setting
|
text
|
N |
applied
|
bool
|
N |
error
|
text
|
N |
pg_hba_file_rules
The pg_hba_file_rules
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
rule_number
|
int8
|
N |
file_name
|
text
|
N |
line_number
|
int8
|
N |
type
|
text
|
N |
database
|
text[]
|
N |
user_name
|
text[]
|
N |
address
|
text
|
N |
netmask
|
text
|
N |
auth_method
|
text
|
N |
options
|
text[]
|
N |
error
|
text
|
N |
pg_indexes
The pg_indexes
view has content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
schemaname
|
text
|
Y |
tablename
|
text
|
Y |
indexname
|
text
|
Y |
tablespace
|
text
|
N |
indexdef
|
text
|
N |
pg_matviews
The pg_matviews
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
schemaname
|
text
|
N |
matviewname
|
text
|
N |
matviewowner
|
text
|
N |
tablespace
|
text
|
N |
hasindexes
|
bool
|
N |
ispopulated
|
bool
|
N |
definition
|
text
|
N |
pg_policies
The pg_policies
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
schemaname
|
text
|
N |
tablename
|
text
|
N |
policyname
|
text
|
N |
permissive
|
text
|
N |
roles
|
text[]
|
N |
cmd
|
text
|
N |
qual
|
text
|
N |
with_check
|
text
|
N |
pg_prepared_xacts
The pg_prepared_xacts
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
transaction
|
int8
|
N |
gid
|
text
|
N |
prepared
|
timestamptz
|
N |
owner
|
text
|
N |
database
|
text
|
N |
pg_publication_tables
The pg_publication_tables
view
has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
pubname
|
text
|
N |
schemaname
|
text
|
N |
tablename
|
text
|
N |
attnames
|
text[]
|
N |
rowfilter
|
text
|
N |
pg_roles
The pg_roles
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
rolname
|
text
|
N |
rolsuper
|
bool
|
N |
rolinherit
|
bool
|
N |
rolcreaterole
|
bool
|
N |
rolcreatedb
|
bool
|
N |
rolcanlogin
|
bool
|
N |
rolreplication
|
bool
|
N |
rolconnlimit
|
int8
|
N |
rolpassword
|
text
|
N |
rolvaliduntil
|
timestamptz
|
N |
rolbypassrls bool
|
bool
|
N |
rolconfig
|
text[]
|
N |
oid
|
oid
|
N |
pg_rules
The pg_rules
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
schemaname
|
text
|
N |
tablename
|
text
|
N |
rulename
|
text
|
N |
definition
|
text
|
N |
pg_sequences
The pg_sequences
view has content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
schemaname
|
text
|
Y |
sequencename
|
text
|
Y |
sequenceowner
|
text
|
N |
start_value
|
int8
|
Y |
min_value
|
int8
|
N |
max_value
|
int8
|
N |
increment_by
|
int8
|
N |
cycle
|
bool
|
Y |
cache_size
|
int8
|
Y |
last_value
|
int8
|
N |
pg_settings
The pg_settings
view has content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
name
|
text
|
Y |
setting
|
text
|
Y |
unit
|
text
|
N |
category
|
text
|
Y |
short_desc
|
text
|
Y |
extra_desc
|
text
|
N |
context
|
text
|
Y |
vartype
|
text
|
Y |
source
|
text
|
Y |
min_val
|
text
|
Y |
max_val
|
text
|
Y |
enumvals
|
text[]
|
N |
boot_val
|
text
|
Y |
reset_val
|
text
|
Y |
sourcefile
|
text
|
N |
sourceline
|
int8
|
N |
pending_restart
|
bool
|
Y |
pg_shmem_allocations
The pg_shmem_allocations
view has no content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
name
|
text
|
N |
off
|
int8
|
N |
size
|
int8
|
N |
allocated_size
|
int8
|
N |
pg_tables
The pg_tables
view has content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
schemaname
|
text
|
Y |
tablename
|
text
|
Y |
tableowner
|
text
|
N |
tablespace
|
text
|
N |
hasindexes
|
bool
|
Y |
hasrules
|
bool
|
N |
hastriggers
|
bool
|
N |
rowsecurity
|
bool
|
N |
pg_views
The pg_views
view has content.
The following table shows whether columns have content.
| Column name | Type | Has content |
|---|---|---|
schemaname
|
text
|
Y |
viewname
|
text
|
Y |
viewowner
|
text
|
N |
definition
|
text
|
Y |
