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>:
Show quoted text
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