Postgres Pro
Downloads
Home   >   mailing lists

Re: procedure in db - Mailing list pgsql-general

From Pavel Stehule
Subject Re: procedure in db
Date
Msg-id AANLkTi=Zff-=tm1O6U28iqy-jmpQcK194WKeR-=OsMtL@mail.gmail.com
Whole thread Raw
In response to procedure in db  (abcdef <chuikingman@gmail.com>)
List pgsql-general
Tree view 
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
>

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: equivalent of mysql's SET type?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: 9.1 - rewrite less alter table?