I am using postgresql database for my application. I want to take only procedure script backup as .sql file not entire database. Is it possible with postgresql? I am using pgAdmin as UI.
1 Answer
You can dump only the object definitions (which includes the functions) using pg_dump with parameter -s.
More info here - https://www.postgresql.org/docs/current/static/app-pgdump.html
1 Comment
Rugma Manas
Is it possible to export functions only?