X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7443F52A3B for ; Wed, 23 Mar 2005 05:03:43 +0000 (GMT) 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 22978-03 for ; Wed, 23 Mar 2005 05:03:33 +0000 (GMT) Received: from mail.ccl.ru (mail.ccl.ru [195.222.130.78]) by svr1.postgresql.org (Postfix) with ESMTP id 1C97A5295C for ; Wed, 23 Mar 2005 05:03:31 +0000 (GMT) Received: from s02.mz.intra (mail.mz.perm.ru [195.222.139.86]) by mail.ccl.ru (8.13.1/8.13.1) with ESMTP id j2N53Ojp044334; Wed, 23 Mar 2005 10:03:24 +0500 (YEKT) Received: from server1c ([192.168.22.73]) by s02.mz.intra with Microsoft SMTPSVC(6.0.3790.211); Wed, 23 Mar 2005 10:05:41 +0500 Date: Wed, 23 Mar 2005 10:01:03 +0500 From: Mihail Nasedkin X-Mailer: The Bat! (v2.00) CD5BF9353B3B7091 Reply-To: Mihail Nasedkin X-Priority: 3 (Normal) Message-ID: <6843119421.20050323100103@mail.ru> To: bandeng Cc: pgsql-sql@postgresql.org Subject: Re: view function on pg_toast In-Reply-To: <3817e229050322193958e2837a@mail.gmail.com> References: <3817e229050322193958e2837a@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 23 Mar 2005 05:05:41.0571 (UTC) FILETIME=[F605E130:01C52F65] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.163 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/310 X-Sequence-Number: 20789 Hello, bandeng. March, 23 2005, 8:39:31: b> hello guys, b> I need help. I have functions but it is saved to pg_toast, when I b> dump the database, the function from pg_toast is not copied. so is b> there any sql or syntax to view function data ? xxx:=\d pg-catalog.pg_proc xxx:=select procsrc from pg-catalog.pg_proc where proname=... and pronamespace=...; -- Regards, Mihail Nasedkin mailto:m.nasedkin.perm@mail.ru