Resumo de comandos úteis do PostgreSQL

sudo su postgres -c psql postgres

ALTER USER postgres WITH PASSWORD 'sua_senha';

createdb -U username -E utf8 dbname -h localhost

create database dbname with owner=postgres encoding='utf8';

alter database "old_name" rename to "new_name";

drop database dbname;

pg_dump dbname -h localhost -U postgres > backup.sql

pg_dump dbname -h localhost -U postgres > backup.sql --table=nome_tabela;

pg_dump dbname -h localhost -U postgres > backup.sql --table=nome_tabela --table=outra_tabela;

pg_dump dbname -h localhost -U postgres > backup.sql --exclude-table=nome_tabela;

pg_dump dbname -h localhost -U postgres > backup.sql --exclude-table=nome_tabela --exclude-table=outra_tabela;

psql dbname -h localhost -U postgres < backup.sql

pg_dumpall -g -U postgres -h localhost > users.sql

select (current_date + integer '7') as nome_campo;

PGError: ERROR: duplicate key value violates unique constraint "tablename_pkey"

select setval('entities_id_seq', (select max(id) from entities)+1);

\pset pager off
\pset pager off
\pset pager always
\pset pager occasionally
\pset pager at random`

\pset null '(null)'