/SQL/Restore backup "text" postgresql command line

Restore backup "text" postgresql command line

-- My solution was using DBeaver without using commands

psql -U username -d dbname < filename.sql

-- For Postgres versions 9.0 or earlier
psql -U username -d dbname -1 -f filename.sql

Source: coderedirect.com

Similar codes

8 votes193 views1 answer
Mysql limit rows
SQL
0 vote184 views1 answer
Why mysql is used?
SQL
0 vote231 views1 answer
How to check rollback status in oracle
SQL
8 votes203 views1 answer
Declare table variable sql server
SQL
12 votes194 views4 answers
Mysql version
SQL
1 vote196 views2 answers
Rebuild index sql server
SQL
0 vote195 views1 answer
Search from comma separated values in sql server
SQL
0 vote183 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote199 views3 answers
Sql query checker
SQL
2 votes194 views1 answer
Oracle index size
SQL