X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 827EBD920C for ; Fri, 23 Sep 2005 11:06:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76471-02 for ; Fri, 23 Sep 2005 14:06:48 +0000 (GMT) Received: from tamar.dmr.co.uk (tamar.dmr.co.uk [195.112.52.166]) by svr1.postgresql.org (Postfix) with ESMTP id D626ED91A5 for ; Fri, 23 Sep 2005 11:06:47 -0300 (ADT) Received: from HFPORT.dmr.co.uk (pennsoft.gotadsl.co.uk [81.6.232.68]) by tamar.dmr.co.uk (8.12.11/8.12.11) with ESMTP id j8NE6nBH007270 for ; Fri, 23 Sep 2005 15:06:50 +0100 Message-Id: <5.1.0.14.0.20050923150802.03484f38@mailserver.dmr.co.uk> X-Sender: hf1@mailserver.dmr.co.uk X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Fri, 23 Sep 2005 15:09:52 +0100 To: Pgsql-sql@postgresql.org From: Hilary Forbes Subject: Where are user defined functions stored? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/226 X-Sequence-Number: 22773 If I write a rule, I can easily see it by doing select * from pg_rules; and I also get to see all the rules I have created for my database. How can I easily get to see the definition of a user defined function please? I've searched through the online manual but failed to find the answer. TAI Hilary Hilary Forbes The DMR Information and Technology Group (www.dmr.co.uk) Direct tel 01689 889950 Fax 01689 860330 DMR is a UK registered trade mark of DMR Limited **********************************************************