PSQL Commands Cheat Sheet
Here is a cli commands cheat sheet for PSQL command, you can use this as a quick reminder for basic commands with a brief description for each of the commands.
What is PSQL command?
Add some data here
# psql is the PostgreSQL terminal interface. The following commands were tested on version 9.5.
# Connection options:
# -U username (if not specified current OS user is used).
# -p port.
# -h server hostname/address.
# Connect to a specific database:
psql -U -h -d
# Get databases on a server:
psql -U -h --list
# Execute sql query and save output to file:
psql -U -d -c 'select * from tableName;' -o
# Execute query and get tabular html output:
psql -U -d -H -c 'select * from tableName;'
# Execute query and save resulting rows to csv file:
# (if column names in the first row are not needed, remove the word 'header')
psql -U -d -c 'copy (select * from tableName) to stdout with csv header;' -o
# Read commands from file:
psql -f
# Restore databases from file:
psql -f
Check out the PSQL command documentation .
You can also check our MegaSh cheatsheet tool, that has 150+ searchable linux cheat sheets in one page, so you never forget a command as you work again
Check Also
