Horton

Re: Specific objects backup in PostgreSQL

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: nikhil kumar <nikhil.dba97@gmail.com>
Cc: pgsql-performance@postgresql.org
Date: 2024-07-10T18:41:01Z
Lists: pgsql-performance 
On Wed, Jul 10, 2024 at 11:05 AM nikhil kumar <nikhil.dba97@gmail.com>
wrote:

>
> 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.
>

This hardly qualifies as a performance question.

You might try the -general list if you want to brainstorm workarounds
because pg_dump itself doesn't provide any command line options to give you
this specific subset of your database.

David J.