Changes
Jump to navigation
Jump to search
Working with PostgreSQL (view source)
Revision as of 20:59, 15 February 2011
, 20:59, 15 February 2011no edit summary
pg_restore -d DBName db.backup
==Working with psql==
To connect your psql client to a db type (for localhost don't specify the host):
psql -h host DBName
Useful commands are:
\q Quits
==SQL Commands==
There is a list of [http://www.postgresql.org/docs/7.3/static/sql-commands.html SQL commands] that may help.