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.