Thread: where the stored function meta data can be found?
Hello, everybody I tried to find where in pg_catalog stored functions are stored, but with no success. Are they available in pg_catalog at all? I have to find all the procedures that delete data from one of my tables. I hope there's a better way to do that than simply search function by function.... -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050
Attachment
Hello,
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael Domiciano
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael Domiciano
On Fri, Oct 2, 2009 at 3:57 AM, Julius Tuskenis <julius@nsoft.lt> wrote:
Hello, everybody
I tried to find where in pg_catalog stored functions are stored, but with no success. Are they available in pg_catalog at all?
I have to find all the procedures that delete data from one of my tables. I hope there's a better way to do that than simply search function by function....
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
Use pgadmin
Date: Fri, 2 Oct 2009 13:35:51 -0300
Subject: Re: [ADMIN] where the stored function meta data can be found?
From: rafael.domiciano@gmail.com
To: julius@nsoft.lt
CC: pgsql-admin@postgresql.org
Hello,
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael Domiciano
Date: Fri, 2 Oct 2009 13:35:51 -0300
Subject: Re: [ADMIN] where the stored function meta data can be found?
From: rafael.domiciano@gmail.com
To: julius@nsoft.lt
CC: pgsql-admin@postgresql.org
Hello,
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael Domiciano
On Fri, Oct 2, 2009 at 3:57 AM, Julius Tuskenis <julius@nsoft.lt> wrote:
Hello, everybody
I tried to find where in pg_catalog stored functions are stored, but with no success. Are they available in pg_catalog at all?
I have to find all the procedures that delete data from one of my tables. I hope there's a better way to do that than simply search function by function....
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
Hello, Rafael
Thank you. Don't know how I've missed that table in pg_catalog...
2009.10.02 19:35, Rafael Domiciano rašė:
Thank you. Don't know how I've missed that table in pg_catalog...
2009.10.02 19:35, Rafael Domiciano rašė:
Hello,
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael DomicianoOn Fri, Oct 2, 2009 at 3:57 AM, Julius Tuskenis <julius@nsoft.lt> wrote:Hello, everybody
I tried to find where in pg_catalog stored functions are stored, but with no success. Are they available in pg_catalog at all?
I have to find all the procedures that delete data from one of my tables. I hope there's a better way to do that than simply search function by function....
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
-- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050