PostgreSQL基础 psql 查看视图的定义

原创云散月明 All China Database Union 2022-07-17

2943

CentOS 7.6.1810
postgresql 14.4

psql 查看视图的定义

[postgres@localhost bin]$ psql
psql (14.4)
Type "help" for help.

postgres=# \d+ pg_stat_activity;
                                  View "pg_catalog.pg_stat_activity"
      Column      |           Type           | Collation | Nullable | Default | Storage  | Description 
------------------+--------------------------+-----------+----------+---------+----------+-------------
 datid            | oid                      |           |          |         | plain    | 
 datname          | name                     |           |          |         | plain    | 
 pid              | integer                  |           |          |         | plain    | 
 leader_pid       | integer                  |           |          |         | plain    | 
 usesysid         | oid                      |           |          |         | plain    | 
 usename          | name                     |           |          |         | plain    | 
 application_name | text                     |           |          |         | extended | 
 client_addr      | inet                     |           |          |         | main     | 
 client_hostname  | text                     |           |          |         | extended | 
 client_port      | integer                  |           |          |         | plain    | 
 backend_start    | timestamp with time zone |           |          |         | plain    | 
 xact_start       | timestamp with time zone |           |          |         | plain    | 
 query_start      | timestamp with time zone |           |          |         | plain    | 
 state_change     | timestamp with time zone |           |          |         | plain    | 
 wait_event_type  | text                     |           |          |         | extended | 
 wait_event       | text                     |           |          |         | extended | 
 state            | text                     |           |          |         | extended | 
 backend_xid      | xid                      |           |          |         | plain    | 
 backend_xmin     | xid                      |           |          |         | plain    | 
 query_id         | bigint                   |           |          |         | plain    | 
 query            | text                     |           |          |         | extended | 
 backend_type     | text                     |           |          |         | extended | 
View definition:
 SELECT s.datid,
    d.datname,
    s.pid,
    s.leader_pid,
    s.usesysid,
    u.rolname AS usename,
    s.application_name,
    s.client_addr,
    s.client_hostname,
    s.client_port,
    s.backend_start,
    s.xact_start,
    s.query_start,
    s.state_change,
    s.wait_event_type,
    s.wait_event,
    s.state,
    s.backend_xid,
    s.backend_xmin,
    s.query_id,
    s.query,
    s.backend_type
   FROM pg_stat_get_activity(NULL::integer) s(datid, pid, usesysid, application_name, state, query, wait_event_type, wait_event, xact_start, query_start, backend_start, state_change, client_addr, client_hostname, client_port, backend_xid, backend_xmin, backend_type, ssl, sslversion, sslcipher, sslbits, ssl_client_dn, ssl_client_serial, ssl_issuer_dn, gss_auth, gss_princ, gss_enc, leader_pid, query_id)
     LEFT JOIN pg_database d ON s.datid = d.oid
     LEFT JOIN pg_authid u ON s.usesysid = u.oid;


复制