Re: Stored FUnctions

select * from pg_proc where proname = ''

Sincerely,

Joshua D. Drake


Rich Hall wrote:

> Thanks for the psql response.
>
> But, I seldom use psql. I find PG Manager much more useful. Even PG
> Admin was better.
>
> I am looking to write some stored functions to query the database to
> automatically create the repotrs I now generate by hand.
> So I was trying to find my Stored Functions in the database so I could
> query them.
>
> Rick
>
>
> Martijn van Oosterhout wrote:
>
>> On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote:
>>
>>
>>> Can somebody tell me how Stored Functions are kept in the database?
>>> I've gone through the catalog several times. I've found many
>>> interesting things but NOT the 300-odd functions I've created.
>>>
>>> Rick
>>>
>>
>>
>> \df
>>
>>
>>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL