Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: what is delete in sql
Sql :: procedure syntax
Sql :: show database not empty tables postgres
Sql :: how to limited number of rows in db2 select * from imglib FETCH FIRST 20 ROWS ONLY
Sql :: load data from text file to mysql database on mac terminal
Sql :: insert using condition postgres
Sql :: exclude last comma separated string mysql
Sql :: postgres show table schema
Sql :: sql server size of every table in a db
Sql :: sql field equals multiple values
Sql :: MySql Subtract a table from another
Sql :: bigquery information_schema schema all columns
Sql :: triggers in mysql example
Sql :: mysql not null
Sql :: rownum in sql
Sql :: duplicate key value violates unique constraint "django_admin_log_pkey"
Sql :: postgres sql alter table delete row
Sql :: List MySQL Table and Index Size
Sql :: update sql
Sql :: default column value in sql same as another column laravel
Sql :: create a database mysql
Sql :: query only first letter string
Sql :: select query in sql
Sql :: sql order by clause
Sql :: sql query to delete duplicate records
Sql :: sql case sttement with set
Sql :: postgres ERROR: relation "user" does not exist
Sql :: sql create table as
Sql :: sqlite3.OperationalError: near "7": syntax error
Sql :: sqlite csv

Search

SQL

copy data from one postgres container to another

ADD CONTENT