Basic PostgreSQL Commands
-
14 Apr 2013
Connect
$ psql -h [hostname] -p [port]
# Default port: 543
Example
$ psql -h localhost
Create DB
$ CREATE DATABASE [database_name];
Delete DB
$ DROP DATABASE [database_name];
Disconnect
$ \q