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 F307353214 for ; Wed, 23 Mar 2005 05:11:56 +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 25321-01 for ; Wed, 23 Mar 2005 05:11:54 +0000 (GMT) Received: from mail.ccl.ru (mail.ccl.ru [195.222.130.78]) by svr1.postgresql.org (Postfix) with ESMTP id 4C89A5320A for ; Wed, 23 Mar 2005 05:11:48 +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 j2N5BeSE048376; Wed, 23 Mar 2005 10:11:40 +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:13:57 +0500 Date: Wed, 23 Mar 2005 10:09:19 +0500 From: Mihail Nasedkin X-Mailer: The Bat! (v2.00) CD5BF9353B3B7091 Reply-To: Mihail Nasedkin X-Priority: 3 (Normal) Message-ID: <14443615312.20050323100919@mail.ru> To: bandeng Cc: pgsql-sql@postgresql.org Subject: Re: view function on pg_toast In-Reply-To: <6843119421.20050323100103@mail.ru> References: <3817e229050322193958e2837a@mail.gmail.com> <6843119421.20050323100103@mail.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 23 Mar 2005 05:13:57.0491 (UTC) FILETIME=[1D9D4430:01C52F67] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.157 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/311 X-Sequence-Number: 20790 MN> 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 ? MN> xxx:=\d pg-catalog.pg_proc xxx:=\d pg_catalog.pg_proc MN> xxx:=select procsrc from pg-catalog.pg_proc where proname=... and MN> pronamespace=...; xxx:=select procsrc from pg_catalog.pg_proc where proname=... and pronamespace=...; -- Regards, Mihail Nasedkin mailto:m.nasedkin.perm@mail.ru