SMALL postgres in docker dump

small_db_dump.sh

#!/bin/bash

# Dump PostgreSQL in Docker with table name, slow as hell but usefull for finding weird values on SMALL databases
DB="furu"
OD="/tmp"
docker exec -t pg psql -t -d $DB -P pager=off -U postgres -c "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type = 'BASE TABLE'"| tr -d '\r'| grep -v '^$' | while read table; do docker exec -t pg pg_dump -U postgres -d $DB -t $table > "$OD/${table}.sql" ; done