\df+ and pg_proc query

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: \df+ and pg_proc query
Date: 2001-07-12 19:34:08
Message-ID: Pine.LNX.4.21.0107121531450.8482-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 the first method (the \df+ ). Is it not possible to have the \df actually show up all functions?

TIA,
thalis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2001-07-12 19:34:35 Re: vacuum and 24/7 uptime
Previous Message Guy Fraser 2001-07-12 19:06:55 Re: A small question about Red Hat