If you start psql with the -E option it will show you the query it runs
when it executes \df.
On 2000-01-29, Graeme Merrall mentioned:
> Hey all.
> I know ermm.. \df prints out all functions (not near my pgsql box!) but is
> there an SQL query to produce the same results?
> 
> Cheers,
>  Graeme
> 
> 
> ************
> 
> 
-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e(at)gmx(dot)net                   75262 Uppsala
http://yi.org/peter-e/            Sweden