\df+ and pg_proc query

Поиск
Список
Период
Сортировка
От Thalis A. Kalfigopoulos
Тема \df+ and pg_proc query
Дата
Msg-id Pine.LNX.4.21.0107121531450.8482-100000@aluminum.cs.pitt.edu
обсуждение исходный текст
Список 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 по дате отправления: