/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

12 votes355 views6 answers
How to install sqlite3 in python
SQL
5 votes351 views1 answer
Sql table columns
SQL
0 vote317 views1 answer
Console output pl sql
SQL
4 votes310 views2 answers
Tables in sql
SQL
0 vote320 views1 answer
Mysql table variables
SQL
0 vote320 views1 answer
Python mysqlclient library not found for -lssl
SQL
1 vote337 views2 answers
Begin transaction in sql
SQL
9 votes345 views3 answers
Date format in sql
SQL
8 votes330 views4 answers
How to calculate the age from date of birth in python
SQL
10 votes335 views4 answers
Drop primary key
SQL