/SQL/Copy data from one postgres container to another

Copy data from one postgres container to another

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
cat your_dump.sql | docker exec -i your-db-container psql -U postgres

Source: stackoverflow.com

Similar codes

0 vote318 views1 answer
Nvl2 syntax
SQL
104 votes501 views2 answers
Like in mysql
SQL
0 vote292 views2 answers
How to get last inserted id in sql server c#
SQL
3 votes325 views3 answers
Mysql auto increment after delete
SQL
0 vote287 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote298 views1 answer
Postgres drop type
SQL
1 vote296 views1 answer
Delete specific row in sql
SQL
0 vote304 views1 answer
Ms sql filter all sympbol
SQL
0 vote305 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
2 votes290 views1 answer
Oracle current date without time
SQL