Starting Postgres

From SQLZOO
Revision as of 10:41, 19 July 2012 by Connor (Talk | contribs)

(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.

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense