Re: Specific objects backup in PostgreSQL

2024-07-10 Thread nikhil kumar
Thank you everyone for your help On Thu, 11 Jul, 2024, 1:34 am Anthony Sotolongo, wrote: > Hi Nikhil, maybe you can apply some tricks playing with pg_dump -s and > pg_restore --list > > > check this link: https://stackoverflow.com/a/13758324/8308381 > > > Regards > > On 10-07-24 14:05, nikhil ku

Re: Specific objects backup in PostgreSQL

2024-07-10 Thread Anthony Sotolongo
Hi Nikhil, maybe you can apply some tricks playing with pg_dump -s and pg_restore --list check this link: https://stackoverflow.com/a/13758324/8308381 Regards On 10-07-24 14:05, nikhil kumar wrote: Dear Team, We received a request from client. They required all functions, stored procedure

Re: Specific objects backup in PostgreSQL

2024-07-10 Thread Olivier Gautherot
Hi Nikhil, On Wed, Jul 10, 2024 at 8:05 PM nikhil kumar 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, > Pos

Re: Specific objects backup in PostgreSQL

2024-07-10 Thread David G. Johnston
On Wed, Jul 10, 2024 at 11:05 AM nikhil kumar 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

Specific objects backup in PostgreSQL

2024-07-10 Thread nikhil kumar
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.