[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 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
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 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings