Postgres
From Leo's Notes
This page was last edited on 12 November 2019, at 18:37.
Tasks
= Init DB
# service postgresql initdb
Hint: the preferred way to do this is now "postgresql-setup initdb"
Initializing database ... OK
Client
The command-line client for PosgreSQL is psql. Connect by running psql as root or as a particular user. Alternatively, specify the username, password, and host:
# psql -U ctxvda -W -h localhost citrix-confdb
## -U for username
## -W to prompt for a password
## -h for hostname
## and the database name
Once in the psql console databases can be listed with \l:
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
---------------+----------+----------+-------------+-------------+-----------------------
citrix-confdb | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)
A database can be selected or changed with \c.
postgres=# \c citrix-confdb
You are now connected to database "citrix-confdb" as user "postgres".
Tables can be listed with \dt:
citrix-confdb=# \dt
List of relations
Schema
Records can be selected. However, if the table name is in mixed case, the table name needs to be in quotes.
citrix-confdb=> SELECT * FROM "Value" ;
ID | Name | ValueDWORD | ValueSZ | ValueMultiSZ | ValueBinary | KeyID
-----+-----------------------------------------+------------+-----------------------------------------------------------+--------------+-------------+-------
1 | Copyright | | Copyright 2016 Citrix Systems, Inc. All Rights Reserved. | | | 13
2 | DotVersion | 15 | | | | 13
...