Re: Which meta table contain the functions - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Which meta table contain the functions
Date
Msg-id 162867790706160504v479f5540sf25cc8e13bba7d41@mail.gmail.com
Whole thread Raw
In response to Which meta table contain the functions  ("Alfred Zhao" <rongkai.zhao@gmail.com>)
List pgsql-general
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
>

pgsql-general by date:

Previous
From: Tom Allison
Date:
Subject: Re: INSERT ... RETURNING in v8.2
Next
From: Michael Fuhr
Date:
Subject: Re: Which meta table contain the functions