toolkitbox/postgres repository overview

# Interactive mode
docker run -it --rm \
  -e PGPASSWORD=my_password \
  ghcr.io/pabpereza/toolkitbox/postgres:latest \
  psql -h my-server.com -U postgres -d my_database

# Run single query
docker run --rm \
  -e PGPASSWORD=my_password \
  ghcr.io/pabpereza/toolkitbox/postgres:latest \
  psql -h my-server.com -U postgres -d my_database -c "SELECT version();"

apiVersion: v1
kind: Pod
metadata:
  name: postgres-client
spec:
  containers:
  - name: postgres-client
    image: ghcr.io/pabpereza/toolkitbox/postgres:latest
    command: ["sleep", "infinity"]
    env:
    - name: PGHOST
      value: "postgres-service"
    - name: PGUSER
      value: "postgres"
    - name: PGPASSWORD
      valueFrom:
        secretKeyRef:
          name: postgres-credentials
          key: password
    - name: PGDATABASE
      value: "mydb"

psql -h hostname -U user -d database

psql "postgresql://user:password@hostname:5432/database"

psql -h hostname -U user -d database -c "SELECT * FROM table"

psql -h hostname -U user -d database -f script.sql

pg_dump -h hostname -U user database > backup.sql

pg_dump -h hostname -U user -Fc database > backup.dump

pg_restore -h hostname -U user -d database backup.dump

pg_isready -h hostname -p 5432

-- List databases
\l

-- Connect to another database
\c database_name

-- List tables
\dt

-- Describe table
\d table_name

-- List users
\du

-- Show command help
\?

-- Execute system command
\! ls -la

-- Quit
\q