Re: Which meta table contain the functions

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: rongkai(dot)zhao(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Which meta table contain the functions
Date: 2007-06-16 12:04:57
Message-ID: 162867790706160504v479f5540sf25cc8e13bba7d41@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)zhao(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-06-16 12:18:49 Re: Which meta table contain the functions
Previous Message Tom Allison 2007-06-16 12:04:10 Re: INSERT ... RETURNING in v8.2