PostgreSQL system catalog views
This page lists the PostgreSQL system catalog views thatSpanner supports.
pg_available_extension_versions
Thepg_available_extension_versionsview 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
Thepg_available_extensionsview 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
Thepg_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
Thepg_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
Thepg_file_settingsview 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
Thepg_hba_file_rulesview 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
Thepg_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
Thepg_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
Thepg_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
Thepg_prepared_xactsview 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
Thepg_publication_tablesviewhas 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
Thepg_rolesview 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
Thepg_rulesview 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
Thepg_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
Thepg_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
Thepg_shmem_allocationsview 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
Thepg_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
Thepg_viewsview 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
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-15 UTC.