Postgres: Difference between revisions
From Leo's Notes
This page was last edited on 25 November 2019, at 20:12.
mNo edit summary |
m →= Init DB: format |
||
| Line 1: | Line 1: | ||
== Tasks == | == Tasks == | ||
=== Init DB == | === Init DB === | ||
{{highlight|lang=terminal|code= | {{highlight|lang=terminal|code= | ||
# service postgresql initdb | # service postgresql initdb | ||
| Line 7: | Line 7: | ||
Initializing database ... OK | Initializing database ... OK | ||
}} | }} | ||
== Client == | == Client == | ||
Revision as of 20:12, 25 November 2019
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
...