Thread: procedure in db
I use postgresql in red hat linux . I want to know how I can find out all the procedure stored in the database . Any SQL command to do it ??? -- View this message in context: http://postgresql.1045698.n5.nabble.com/procedure-in-db-tp3414995p3414995.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Hello 2011/3/9 abcdef <chuikingman@gmail.com>: > I use postgresql in red hat linux . > I want to know how I can find out all the procedure stored in the database . > Any SQL command to do it ??? > you can try \df in psql or select * from pg_proc Regards Pavel Stehule > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/procedure-in-db-tp3414995p3414995.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
On Mar 9, 2011, at 9:56 AM, abcdef wrote: > I use postgresql in red hat linux . > I want to know how I can find out all the procedure stored in the database . > Any SQL command to do it ??? pg_catalog.pg_proc can be use to find all the functions. Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.kumar@enterprisedb.com Blog:http://vibhork.blogspot.com