/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

16 votes211 views5 answers
Select last row in sql
SQL
9 votes210 views5 answers
Laravel to sql
SQL
0 vote197 views1 answer
Oracle table free space
SQL
1 vote202 views1 answer
How to check the mysql version mac
SQL
1 vote216 views1 answer
Get current date in pyspark sql
SQL
36 votes200 views6 answers
Rename table sql
SQL
0 vote182 views1 answer
Mysql money value
SQL
0 vote201 views1 answer
How to create a new shema using query languaage
SQL
0 vote227 views1 answer
Sql multiple into
SQL
-1 vote184 views1 answer
Search all database tables for a value sqlserver
SQL