PostgreSQL

Installation

Arch Linux

yay -S postgresql
su - postgres -c "initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'"
sudo systemctl enable postgresql
sudo systemctl start postgresql

Ubuntu / Debian

sudo apt install postgresql

Exporting / Importing

Into a sql file

sudo -u postgres pg_dump databas > /tmp/database.sql

Into a csv file

sudo -u postgres psql
\c database
\copy (SELECT * FROM table_name) TO '/tmp/table.csv' DELIMITER ',' CSV HEADER

From a sql file

sudo -u postgres psql -d database -f database.sql

From one table to another

pg_dump -U postgres -t   | psql -U postgres -d 

Commands

List all databases

\l

Connect to database

\c database

Common Tasks

Renaming a Table

ALTER DATABASE people RENAME TO customers;