Starting Postgres

From SQLZOO
Revision as of 10:41, 19 July 2012 by Connor (Talk | contribs) (Created page with "<table border="1"> <tr> <th colspan="1" rowspan="1" width="296">Name of the server</th> <td colspan="1" rowspan="1" width="576">postgres</td> </tr> <tr> <th colspan="1" rowsp...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Name of the server postgres
Name of the client psql
Typical command line to start the client psql -h server -d dbname -U username

server

the internet address of a computer running the server

dbname

the name of the database to use

username

database user name

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.