Re: Specific objects backup in PostgreSQL

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