postgresql restore dump sql code example

Example 1: postgresql restore from dump

psql -U postgres -h localhost -p 5432 -f data_dump.sql

Example 2: psql load dump

psql databasename < data_base_dump