Re: procedure in db

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: abcdef <chuikingman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: procedure in db
Date: 2011-03-09 07:46:48
Message-ID: AANLkTi=Zff-=tm1O6U28iqy-jmpQcK194WKeR-=OsMtL@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

2011/3/9 abcdef <chuikingman(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-03-09 07:59:24 Re: 9.1 - rewrite less alter table?
Previous Message John R Pierce 2011-03-09 05:41:31 Re: equivalent of mysql's SET type?