PostgreSQL system catalog views

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_tablesview 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

What's next

• System catalogs