Starting Postgres
Name of the server | postgres |
---|---|
Name of the client | psql |
Typical command line to start the client | psql -h server -d dbname -U username
|
Useful commands | \? \dt \i file.sql \c otherdbname |
Beware! |
If results are wide the format is unreadable. \pset pager |
Thanks to Nicola Boni from Italy for supplying this.