Starting Postgres

From SQLZoo
Jump to navigation Jump to 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


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.

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects