POSTGRES DOCKER COMPOSE

postgres.docker-compose.md

DUMP ALL

docker-compose exec -u postgres postgres pg_dumpall -c > prod_`date +%d-%m-%Y"_"%H_%M_%S`.sql

DUMP TABLE FROM DATABASE

docker-compose exec -u postgres postgres pg_dump -d "DATABASE" -t 'TABLE' > TABLE_`date +%d-%m-%Y"_"%H_%M_%S`.sql

EXPORT TABLE TO CSV

docker-compose exec -u postgres postgres psql -d "DATABASE" -c `copy TABLE to stdout with csv header` > TABLE.csv

IMPORT TABLE FROM CSV

docker-compose exec -T -u postgres postgres psql -d "DATABASE" -c "copy TABLE from stdin with delimiter \";\" csv header" < TABLE.csv

NOTE: update table id sequence select setval('TABLE_id_seq', select max(id) from TABLE);