SEO

#1 (**permalink**) 04-10-2008, 06:51 AM

Hi,

I'm new to postgres and i cant find how can i get a function code from the database.

10x
Doron

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-10-2008, 06:51 AM

select prosrc from pg_proc where proname = '<function_name>';

However you cannot see the code of C language function with this query.

is that what you wanted?

--Imad
www.EnterpriseDB.com

On 11/27/06, Doron Baranes <doron.baranes@dbnet.co.il> wrote:
>
> Hi,
>
> I'm new to postgres and i cant find how can i get a function code from the database.
>
> 10x
> Doron
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Functions