psql load dump
snippet in sql

how to take database dump in postgresql

user5675

pg_dump dbname > outfile

psql load dump

user2813

psql databasename < data_base_dump