Обсуждение: where the stored function meta data can be found?

Поиск
Список
Период
Сортировка

where the stored function meta data can be found?

От
Julius Tuskenis
Дата:
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



Вложения

Re: where the stored function meta data can be found?

От
Rafael Domiciano
Дата:
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



Re: where the stored function meta data can be found?

От
Julio Leyva
Дата:
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

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



Re: where the stored function meta data can be found?

От
Julius Tuskenis
Дата:
Hello, Rafael

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 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





-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
Вложения