Answers for "dump sql file to database postgres"

postgres make sql dump

pg_dump -U username dbname > dbexport.pgsql

Posted by: Guest on July-08-2020

import sql dump into postgresql database

psql databasename < data_base_dump

Posted by: Guest on June-09-2021

restore postgresql database from dump file

pg_restore -U sam -d SamDataBase -1 SamDataBaseBackup.sql

Posted by: Guest on April-22-2022

pg dump to db

psql dbname < infile

Posted by: Guest on October-18-2021

dump sql file to database postgres

# First create DATABASE
sudo su postgres
# enter password
createdb testdb
psql db_name < dump.sql

Posted by: Guest on March-14-2022

Code answers related to "dump sql file to database postgres"