Hi Nikhil, On Wed, Jul 10, 2024 at 8:05 PM nikhil kumar <nikhil.db...@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
