pgsql restore table from plain sql file code example

Example: restore postgres database from sql file

psql -d database_name -f backup.sql