X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A54D59DCC64 for ; Thu, 8 Dec 2005 11:07:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77213-01 for ; Thu, 8 Dec 2005 11:07:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from presinet.com (presinet.com [209.53.156.1]) by postgresql.org (Postfix) with ESMTP id 352FE9DCC51 for ; Thu, 8 Dec 2005 11:07:43 -0400 (AST) Received: from [10.10.1.151] ([10.10.1.151]) by presinet.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 8 Dec 2005 07:04:57 -0800 Message-ID: <43984C44.5020803@presinet.com> Date: Thu, 08 Dec 2005 07:07:48 -0800 From: Bricklen Anderson User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Benjamin Arai CC: pgsql-admin@postgresql.org Subject: Re: Backing up views, functions References: <4397D871.20208@cs.ucr.edu> In-Reply-To: <4397D871.20208@cs.ucr.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 08 Dec 2005 15:04:57.0640 (UTC) FILETIME=[C0E99A80:01C5FC08] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/64 X-Sequence-Number: 19784 Benjamin Arai wrote: > I have a database of several million records and we are currently > developing pl functions and views. How do you dump only the code for > views and functions? > > Benjamin > This has come up before, if you search the archives, you'll find various ways of accomplishing this. Here's a start (one way of getting function source) http://archives.postgresql.org/pgsql-general/2005-10/msg01633.php