Answers for "postgres load dump"

SQL
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
Posted by: Guest on March-02-2021
5

how to take database dump in postgresql

pg_dump dbname > outfile
Posted by: Guest on May-12-2020
1

psql load dump

psql databasename < data_base_dump
Posted by: Guest on March-09-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language