Thanks for those who responded. It works fine and lasts a long time.
The following script does NOT require any editing. It simply executes
and works.
\pset format unaligned
\pset fieldsep ''
\pset footer
\t
\o drops.sql
select 'drop function ' || nspname || '.' || proname || '(' ||
pg_catal
Folks,
I am using PGSQL do do all of my schema changes, but have run into a
problem. I need to be able to DROP all of the USER FUNCTIONS that are
defined in a schema. The problem is that I do not know the names of all
of the functions and parameters. I know that I could use '\df' and then
I am running postgres 8.1.2 on both a windows and Linux platform.
The primary method of managing business logic is through the use of
functions. Our primary access to the database is by using PSQL (pg/psql).
The problem that I am having is that we need to execute and implement
"SAVEPOINT" an
