Hilary Forbes <[EMAIL PROTECTED]> writes:
> Many thanks. Suppose I now want to know if there are any user defined
> functions set up in my database? I was rather hoping I could do something
> simple like
> \df
> to get a list of **user** defined functions rather as \dt gives me a list of
> my tables and not the complete list of all the system tables as well. Is
> there a way of achieving this?
You could do something like
\df public.*
although if your functions are scattered through a bunch of different
schemas it'd get a bit tedious. Or try looking at the catalog for
yourself, eg
select oid::regprocedure, prosrc from pg_proc
where pronamespace != (select oid from pg_namespace
where nspname = 'pg_catalog');
This essentially implements the rule "system functions are those in
pg_catalog". You might want to exclude stuff in information_schema
as well.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
