[GENERAL] 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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Which meta table contain the functions

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 [EMAIL PROTECTED]: Group, I can get the function list

Re: [GENERAL] Which meta table contain the functions

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