postgres usage

first things first

assuming postgres admin user not pgsql

default user @netbsd -- pgsql
default user @slackware -- postgres

get into the right prompt with –either–

sudo -u postgres psql

–or–

su - postgres -c psql

–or– yet another way

psql -U postgres

–or– even remotely

psql -h HOST -p PORT -U DBUSER
# -d DBNAME

create database "THAT-DB";

and create a user

create user THAT-USER with password 'PASSWORD-HERE';
grant all on database "that-db" to THAT-USER;
^D

alter user THAT-USER password 'PASSWORD-HERE';

list databases

\list

pick one

\c DBNAME

list tables

\dt

write output to file

\o out.txt
select * from TABLE;
\o
^D

as CSV

psql --csv ...

\o out.csv
select * from TABLE;
\o
^D