Re: How can I display the contents of a function?

Поиск
Список
Период
Сортировка
От A. Kretschmer
Тема Re: How can I display the contents of a function?
Дата
Msg-id 20090119125623.GC2686@a-kretschmer.de
обсуждение исходный текст
Ответ на How can I display the contents of a function?  ("Thom Brown" <thombrown@gmail.com>)
Ответы Re: How can I display the contents of a function?
Список pgsql-general
In response to Thom Brown :
> I would like to see what's in a function.  I can do this if I use pgAdmin III
> just by clicking on the function, and it appears in the SQL pane opposite.  But
> how is this done?  Is there a command like DESCRIBE FUNCTION logging.do_stuff;
> ?  And if possible, doing this without psql.

All details about a function are stored in pg_proc. So you can do a
select on this table to retrieve the source-code.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: How can I display the contents of a function?
Следующее
От: Igor Katson
Дата:
Сообщение: Re: How can I display the contents of a function?