PostgreSQL Quick Reference Guide
Een hulp en handvat of cheatsheet voor configuratie van PostgreSQL.
Connection Arguments
- -h : hostname or IP address or socket directory
- -p : port number
- -U : role name
- -d : database name
- connection string : host=
port= user= dbname= - service file : ~/.pg_service.conf
- gobal service file : pg_service.conf in directory :
- redhat : /etc/sysconfig/pgsql/
- Debian : /etc/postgresql-common
Client psql
Arguments
- -c '
' : run SQL or internal command - -f
: run a file - -1 : run orders in a transaction
- -s : run orders step by step
- -f
Internal commands
- c [ dbname [ username ] [ host ] [ port ] | conninfo ] : open a new connection
- conninfo : display current connection
- l : show databases
- dn : show namespaces (schemas)
- dt : show visible tables
- dx : show installed extensions
- df : show functions
- d
- ! : run a shell command
- i
: run a file - x on|auto|off : toggle expanded display mode
- timing on|off : toggle display running time
- ? : help about internal command
- h : help about SQL orders
- q : quit