Answers for "postgres make backup"

SQL
1

backup postgres database

pg_dump -h localhost -U postgres -W -d mydb > mydb.sql
Posted by: Guest on July-07-2021
0

postgresql backup and restore globals and data

$ psql -U postgres -h localhost -p 5433 < globals.sql
$ psql -U postgres -h localhost -p 5433 < sandbox.sql
Posted by: Guest on June-26-2020
0

postgresql copy backup table

psql -U postgres -d postgres < "C:UsersNilayDesktopIBSfilesfddcerfltsegfddcerfltseg.sql"> C:UsersNilayDesktopIBSfilesfddcerfltseglogerror.log
Posted by: Guest on January-19-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language