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