How to describe a System table

[Jbaskin]

Hi guys,

How do I describe a system table in vsql with the \d meta command?

Code: Select all

dbadmin=> \dS sessions;
                            List of tables
  Schema   |   Name   |  Kind  |         Description         | Comment
-----------+----------+--------+-----------------------------+---------
 v_monitor | sessions | system | Information on each Session |
(1 row)

dbadmin=> \d sessions;
Did not find any relation.

Thanks!

[JimKnicely]

Please check out this thread:

viewtopic.php?f=48&t=269&p=768&hilit=system#p767

[id10t]

HI!

I'm afraid that `v_monitor.sessions` it's VIEW and not TABLE.

[Jbaskin]

Cool, thanks!

The system_columns table has what I'm looking for:

Code: Select all

dbadmin=> select column_name, data_type from system_columns where table_name = 'sessions';
        column_name         |   data_type
----------------------------+---------------
 node_name                  | varchar(128)
 user_name                  | varchar(128)
 client_hostname            | varchar(128)
 client_pid                 | int
 login_timestamp            | timestamptz
 session_id                 | varchar(80)
 client_label               | varchar(256)
 transaction_start          | timestamptz
 transaction_id             | int
 transaction_description    | varchar(8192)
 statement_start            | timestamptz
 statement_id               | int
 last_statement_duration_us | int
 runtime_priority           | varchar(8192)
 current_statement          | varchar(8192)
 last_statement             | varchar(8192)
 ssl_state                  | varchar(80)
 authentication_method      | varchar(80)
 epoch                      | int
(19 rows)

PS> Is the system_columns a table or view