PostgreSQL on the command line
I am just getting back into PostgreSQL. Here are the things I had to learn today:
1. Command line usage:
su - postgres
psql
select version();
2. Dumping data for import on another server
pg_dump -o mydb -U postgres -W > mydb.sql
-o has t...
randy.cc1 min read