PostgreSQL commands

Updated: 28 February 2026

Remove a PostgreSQL database called app as user app

dropdb -U app app

Create a PostgreSQL database

createdb dbname

Use pg_dump, as user app, to backup a database inside docker container pg

docker compose exec pg pg_dump -U app > claude_results.sql

Also see pg_restore