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 |