Postgres Pro
Downloads
Home   >   mailing lists

Re: Specific objects backup in PostgreSQL - Mailing list pgsql-performance

From Olivier Gautherot
Subject Re: Specific objects backup in PostgreSQL
Date
Msg-id CAJ7S9TV-MACXMOL21JXa4y_hcuaNhHuNCSkHjX_Mk0TRgUTH0g@mail.gmail.com
Whole thread Raw
In response to Specific objects backup in PostgreSQL  (nikhil kumar <nikhil.dba97@gmail.com>)
List pgsql-performance
Tree view
Hi Nikhil,

On Wed, Jul 10, 2024 at 8:05 PM nikhil kumar <nikhil.dba97@gmail.com> wrote:
Dear Team,

We received a request from client. They required all functions, stored procedures and triggers backup. can anyone please let me know. How to take backup only above objects. 


Thanks & Regards,
Nikhil, 
PostgreSQL DBA.

"pg_dump -s" will export the model, including functions, triggers... as well as tables and views without data.

I should have somewhere an old program I wrote on a lazy day to slice this backup into individual objects. I can dig it for you if you need it.

Cheers
--
Olivier Gautherot

pgsql-performance by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Specific objects backup in PostgreSQL
Next
From: Anthony Sotolongo
Date:
Subject: Re: Specific objects backup in PostgreSQL