Обсуждение: function defination help ..

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

function defination help ..

От
Rajesh Kumar Mallah
Дата:
Hi,

is it possible to get the function creation defination as produced by pg_dump 
by some SQL queries on system catalogs?

pg_func stores procsrc but i am trying to get RETURNS and the arg part also. 



-- 

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.


Re: function defination help ..

От
Peter Eisentraut
Дата:
Rajesh Kumar Mallah writes:

> is it possible to get the function creation defination as produced by pg_dump
> by some SQL queries on system catalogs?
>
> pg_func stores procsrc but i am trying to get RETURNS and the arg part also.

You will need to reconstruct what pg_dump does.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: function defination help ..

От
Rajesh Kumar Mallah
Дата:
Thank you 

i will look into its source code. 
and try to find some solution for myself.

regds
mallah.


On Saturday 22 February 2003 07:40 am, Peter Eisentraut wrote:
> Rajesh Kumar Mallah writes:
> > is it possible to get the function creation defination as produced by
> > pg_dump by some SQL queries on system catalogs?
> >
> > pg_func stores procsrc but i am trying to get RETURNS and the arg part
> > also.
>
> You will need to reconstruct what pg_dump does.

-- 

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.