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