Thread: Pg backup

Pg backup

From

Nikhil Ingale

Date:

12 October 2022, 13:59:08

Hi All,

How do I take the backup of all the tables (no table data, no functions and other objects) only from one schema and restore to another schema?

Regards,

Nik

Re: Pg backup

From

Laurenz Albe

Date:

12 October 2022, 16:36:51

On Wed, 2022-10-12 at 16:29 +0530, Nikhil Ingale wrote:
> How do I take the backup of all the tables (no table data, no functions and other objects) only from one schema and
restoreto another schema?
 

Perform a dump with

 pg_dump --schema=yourschema --schema-only dbname

Create a new database, restore the dump into the new database, rename the schema there,
dump the new database and drop it, then import the new dump into the original database.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

Re: Pg backup

From

Nikhil Ingale

Date:

13 October 2022, 09:28:24

Thanks, I'll check it out.

On Wed, Oct 12, 2022 at 7:06 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:

On Wed, 2022-10-12 at 16:29 +0530, Nikhil Ingale wrote:
> How do I take the backup of all the tables (no table data, no functions and other objects) only from one schema and restore to another schema?

Perform a dump with

pg_dump --schema=yourschema --schema-only dbname

Create a new database, restore the dump into the new database, rename the schema there,
dump the new database and drop it, then import the new dump into the original database.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com