postgres load dump code example
Example 1: load a dump in postgres 12
# To reload the dump in the database newdb.
pg_restore -d newdb mydumpfile
# To reload the dump in a created db.
psql -Umyuser mydatabase < mydumpfile
Example 2: how to take database dump in postgresql
pg_dump dbname > outfile
Example 3: psql load dump
psql databasename < data_base_dump