First, list the databases on the server:
[postgres@oric-pg01.oric.no ~]$ psql
psql (11.6)
Type "help" for help.
postgres=# \conninfo
You are connected to database "postgres" as user "postgres" via socket in "/var/run/postgresql" at port "5432".
postgres=# \list
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+------------+------------+------------------------------
postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres +
| | | | | postgres=CTc/postgres +
| | | | | postgres_exporter=c/postgres
kldb | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres=CTc/postgres +
template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)
Then, connect to the correct databasepostgres=# \connect kldb You are now connected to database "kldb" as user "postgres".
You can now describe any table in the database:
kldb=# \d kld.actions
Table "kld.actions"
Column | Type | Collation | Nullable | Default
----------------+--------------------------+-----------+----------+-----------------------------------------------------------------
id | integer | | not null | nextval('kld.action_id_seq'::regclass)
qid | character varying(11) | | not null |
systemid | character varying(20) | | not null |
actiontype | character varying(20) | | not null |
relation | character varying(50) | | |
messageheader | character varying(50) | | |
rnumber | character varying(13) | | |
versionID | numeric | | |
errormsg | character varying(4000) | | |
occured_time | timestamp with time zone | | not null | now()
Indexes:
"pk__actions" PRIMARY KEY, btree (id)
"idx__actions_sk1" btree (partsid, systemid, hendelsestype)
You can also use the metacommand "dt" or "dt+", like this:
prod=# \dt+ sales.*
List of relations
Schema | Name | Type | Owner | Size | Description
-----------+------------------------------------+-------+-----------+------------+-------------
sales | mytable1 | table | jim | 8192 bytes |
sales | mytable2 | table | jim | 8192 bytes |
sales | mytable3 | table | jim | 16 kB |
sales | mytable4 | table | jim | 9757 MB |
sales | mytable5 | table | jim | 312 GB |
(5 rows)
No comments:
Post a Comment