Обсуждение: How to list only my functions and their content?
I am in psql. I tried "\dd" but this lists pg_catalog and stuff like that. Long list that I don't need. I scoured through this page -- http://www.postgresql.org/docs/8.3/static/app-psql.html -- and still did not find how to list only my own functions? A regular "\d" shows only tables and views it seems. All I need is to list my own created functions and their code. Thanks for any pointers!
Hello try \df+ your_fce_name regards Pavel Stehule p.s. \? show help 2008/11/19 Phoenix Kiula <phoenix.kiula@gmail.com>: > I am in psql. I tried "\dd" but this lists pg_catalog and stuff like > that. Long list that I don't need. > > I scoured through this page -- > http://www.postgresql.org/docs/8.3/static/app-psql.html -- and still > did not find how to list only my own functions? A regular "\d" shows > only tables and views it seems. > > All I need is to list my own created functions and their code. > > Thanks for any pointers! > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
On 19/11/2008 10:01, Phoenix Kiula wrote: > I am in psql. I tried "\dd" but this lists pg_catalog and stuff like > that. Long list that I don't need. You can add a pattern to \df, so if your functions are in the public schema then do: \df public.* HTH, Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------