Answers for "postgresql 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
3

postgres make sql dump

pg_dump -U username dbname > dbexport.pgsql
Posted by: Guest on July-08-2020
5

how to take database dump in postgresql

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

Code answers related to "SQL"

Browse Popular Code Answers by Language