how to load a dump to postgres 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: postgres make sql dump

pg_dump -U username dbname > dbexport.pgsql