Search
 
SCRIPT & CODE EXAMPLE
 

SQL

restore postgresql database from dump file

pg_restore -U sam -d SamDataBase -1 SamDataBaseBackup.sql
Comment

dump sql file to database postgres

# First create DATABASE
sudo su postgres
# enter password
createdb testdb
psql db_name < dump.sql
Comment

PREVIOUS NEXT
Code Example
Sql :: sql server find all referencing objects to user-defined table type 
Sql :: SQL Server Splitting a string column into multiple rows, while repeating ID column 
Sql :: oracle cpu metric 
Sql :: how to add new column with default value in sql server 
Sql :: get specific column in mongodb 
Sql :: find all tables where column name exists oracle 
Sql :: mysql select database 
Sql :: create postgres role and database for bitbucket 
Sql :: round .5 to 1 in sql server 
Sql :: c# sql conennection string 
Sql :: load data from text file to mysql database on mac terminal 
Sql :: mysqli_free_result 
Sql :: in in sql 
Sql :: sql cte example 
Sql :: delete account in flask and sqlalchemy 
Sql :: mysql average from two table 
Sql :: oracle merge insert if not exists 
Sql :: mysql uuid 
Sql :: how to completely uninstall sql server 
Sql :: FIND ABOVE AVERAGE SALARY EARNER IN SQL 
Sql :: mysql calcular idade 
Sql :: REMOVE DATE FROM DATE TIME SQL SERVER 
Sql :: timestamp to date sql server 
Sql :: how to install mssql on mac 
Sql :: foreign key sql 
Sql :: how to create local postgres database 
Sql :: sql query to delete duplicate records 
Sql :: sql ssrs 
Sql :: mysql current date between two dates 
Sql :: sql composite primary key 
ADD CONTENT
Topic
Content
Source link
Name
5+8 =