Re: \df+ and pg_proc query

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: \df+ and pg_proc query
Дата
Msg-id 008901c10b7b$d9350ca0$1001a8c0@archonet.com
обсуждение исходный текст
Ответ на \df+ and pg_proc query  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Ответы Re: \df+ and pg_proc query  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Список pgsql-general
From: "Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>

> 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?

Start psql with -E and then do \df+ to see what query PG actually uses (this
works for any \command)

- Richard Huxton


В списке pgsql-general по дате отправления:

Предыдущее
От: Keith F Irwin
Дата:
Сообщение: Postgresql & Python 2
Следующее
От: "Richard Huxton"
Дата:
Сообщение: Re: Foreign keys?