Postgres Pro
Downloads
Home   >   mailing lists

Re: How to obtain the code af a function ? - Mailing list pgsql-general

From A. Kretschmer
Subject Re: How to obtain the code af a function ?
Date
Msg-id 20051109145743.GQ30305@webserv.wug-glas.de
Whole thread Raw
In response to How to obtain the code af a function ?  ("ctobini" <ctemp2@free.fr>)
List pgsql-general
Tree view 
am  09.11.2005, um  5:40:14 -0800 mailte ctobini folgendes:
> Hello,
>
> I would like to know how to liste the contain of a fonction.

You can find this in information_schema.routines.


>
> Writing \df in psql, I have a list of functions and triggers, but and
> don't know how to obtain the code of those functions.

Type \df+ <your_function>. Hint: switch with \x


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Postmaster failing to start on reboot
Next
From: Richard Huxton
Date:
Subject: Re: newbie design question re impact of VACUUM