\df+ and pg_proc query - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject \df+ and pg_proc query
Date
Msg-id Pine.LNX.4.21.0107121531450.8482-100000@aluminum.cs.pitt.edu
Whole thread Raw
List pgsql-general
I assume that there is in fact a difference between doing:

\df+ <func_name>

and:

select oid,proname,prosrc from pg_proc where proname='func_name';

because I have a plpgsql function for a trigger, which I can see with the second method (the select...) but not with
thefirst method (the \df+ ). Is it not possible to have the \df actually show up all functions? 

TIA,
thalis


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Pg7.2 (was: vacuum and 24/7 uptime)
Next
From: Martín Marqués
Date:
Subject: Re: vacuum and 24/7 uptime