Answers for "postgre copy command on list of rows"

SQL
1

copy table postgres

CREATE TABLE new_table AS 
TABLE existing_table;
Posted by: Guest on April-08-2020
0

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
Posted by: Guest on June-29-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language