Sql

Search

psql restore from tar

pg_restore -c -U postgres -d client03 -v "/tmp/client03.tar" -W

Comment

psql restore from tar

-c to clean the database
-U to force a user
-d to select the database
-v verbose mode, don't know why
"$$" the location of the files to import in tmp to get around permission issues
-W to force asking for the password to the user (postgres)

Comment

PREVIOUS	NEXT

Code Example
Sql :: funzioni plsql
Sql :: check mysql timezone
Sql :: restart identity cascade
Sql :: import local sql into remote mysql
Sql :: psql is not recognized
Sql :: rails run native ssql query
Sql :: sql copy table structure
Sql :: drop procedure sql
Sql :: sql remanecolumn
Sql :: nvl postgres
Sql :: oracle export trigger ddl
Sql :: postgresql select as and fwhwere by this field
Sql :: sql comment header
Sql :: postgresql division count return 0
Sql :: sql output inserted id
Sql :: describe sql server
Sql :: oracle split string
Sql :: install mysql 8 ubuntu 18.04
Sql :: mysql copy table1 to table2
Sql :: oracle alter table add not null constraint
Sql :: mysql change data type of column
Sql :: postgresql group by month and year
Sql :: Oracle Column Names of a table
Sql :: how to drop a trigger in postgresql
Sql :: how to fetch alternate records from two tables
Sql :: how to select all attributes from a row if there is a certain string in it MySQL
Sql :: postgresql restore from dump
Sql :: ORACLE SHOW AVAILABLE DB LINK
Sql :: sql server format datetime
Sql :: creer une base de donnée psql

Search

SQL

psql restore from tar

psql restore from tar

ADD CONTENT