psql restore db from sql code example

Example: restore postgres database from sql file

psql -d database_name -f backup.sql