Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql restore from dump

psql -U postgres -h localhost -p 5432 -f data_dump.sql
Comment

restore postgres database from dump

psql -U username -d dbname < filename.sql
Comment

postgresql dump and restore db

#To dump a database called mydb into a SQL-script file:
pg_dump mydb > db.sql

#To reload such a script into a (freshly created) database named newdb:
psql -d newdb -f db.sql
Comment

how to take database dump in postgresql

pg_dump dbname > outfile
Comment

restore postgresql database from dump file

pg_restore -U sam -d SamDataBase -1 SamDataBaseBackup.sql
Comment
PREVIOUS NEXT
Code Example
Sql :: input in mysql 
Sql :: how to fetch first 5 characters in sql 
Sql :: db.Database.SqlQuery 
Sql :: get count of duplicate records 
Sql :: join update query in sql 
Sql :: postgres default user 
Sql :: sql backup database statement 
Sql :: sql convert xml to text 
Sql :: postgresql cast 
Sql :: mysql set id auto increment 
Sql :: how to get duplicate records with multiple field in sql 
Sql :: (PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at 
Sql :: pluck in query builder 
Sql :: query less than datetime sql 
Sql :: sql in array query 
Sql :: sql count null 
Sql :: use concat in group_concat 
Sql :: mariadb add foreign key 
Sql :: postgresql insert column 
Sql :: oracle nextval insert 
Sql :: phpmyadmin change password 
Sql :: alter schema sql server 
Sql :: mysql replace remove html tag 
Sql :: sql pagination offset 
Sql :: mysql query dates between two dates 
Sql :: mysql current time 
Sql :: sql convert varchar to date 
Sql :: oracle list grants on procedure 
Sql :: sum query in sql 
Sql :: how to select distinct in mysql 
ADD CONTENT
Topic
Content
Source link
Name
4+3 =