Обсуждение: Which meta table contain the functions

Group,
   I can get the function list via \df. Can someone tell me which meta table
contain the function list? Thanks!

Alfred

Hello

when you start psql with switch -E, then all used sql queries are showed.

try

psql -E yourdb
\df+ yourfce

you can find all functions in pg_proc table or information_schema.routines

Regards
Pavel Stehule

2007/6/16, Alfred Zhao <rongkai.zhao@gmail.com>:
> Group,
>    I can get the function list via \df. Can someone tell me which meta table
> contain the function list? Thanks!
>
> Alfred
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

On Fri, Jun 15, 2007 at 06:47:10PM -0500, Alfred Zhao wrote:
>    I can get the function list via \df. Can someone tell me which meta table
> contain the function list? Thanks!

http://www.postgresql.org/docs/8.2/interactive/catalog-pg-proc.html

You can see the statements that psql runs by starting psql with the
-E (--echo-hidden) option or by executing "\set ECHO_HIDDEN".  This
is a helpful way to learn about the system catalogs.

--
Michael Fuhr