Search
 
SCRIPT & CODE EXAMPLE
 

SQL

restore postgres database from sql file

psql -d database_name -f backup.sql
Comment

restore database postgresql

docker exec -it (container-name) bash # inter container
# go dump file location it will easy to target restore file
psql -U username -d dbname < filename.sql # then run this for restore 
-- For Postgres versions 9.0 or earlier
psql -U username -d dbname -1 -f filename.sql
Comment
PREVIOUS NEXT
Code Example
Sql :: XOR in SQL Server 
Sql :: update all rows mysql 
Sql :: sql last updated 
Sql :: sql update all rows 
Sql :: ora-02391 
Sql :: make a field auto_increment mysql 
Sql :: mysql add fields 
Sql :: mysql remote connection command line 
Sql :: how to create table in sql 
Sql :: mysql get random data 
Sql :: change old domain to new domain name wordpress 
Sql :: dynamic sql invalid table name 
Sql :: sql order by case 
Sql :: find tables with column name in sql 
Sql :: mysql how to change default charset 
Sql :: oracle all source 
Sql :: shrink database file in sql server 
Sql :: sql calculate percentage 
Sql :: Get Minimum from multiple columns sql 
Sql :: get count of duplicate records 
Sql :: tsql insert 
Sql :: select rows with same value in a column 
Sql :: mysql limit rows 
Sql :: sql server update to null 
Sql :: SQL Auto Increment Primary Key - SQL Server 
Sql :: generate sequence number in sql server 
Sql :: check constraint in sql 
Sql :: multiple count in sql 
Sql :: phpmyadmin change password 
Sql :: mysql select update same table 
ADD CONTENT
Topic
Content
Source link
Name
4+2 =