Starting Postgres

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 Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Name of the server postgres
Name of the client psql
Typical command line to start the client psql -h server -d dbname -U username


the internet address of a computer running the server


the name of the database to use


database user name

Useful commands
\i file.sql
\c otherdbname

If results are wide the format is unreadable. \pset pager

Thanks to Nicola Boni from Italy for supplying this.