# The PostgreSQL DBMS

Default user, db: `postgres`

## `psql` CLI

    psql <database> <user>

### Meta commands

- `\c[onnect]`: connects to a database, new server (can specify dbname, username,
host, port, etc., use `-` to leave unspecfied)
- `\dt`: list tables
  - There's a bunch of complicated `\d*` commands

## User management

Everything should be done as user `postgres`.

New user:

    createuser --pwprompt mypguser

Change password:

    # in `psql`
    ALTER ROLE user WITH PASSWORD 'xxx';

## New database

    sudo su postgres
    createdb -O mypguser mypgdatabase

    # delete db
    dropdb mypgdatabase