Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5D72C632331 for ; Mon, 30 Aug 2010 16:02:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 70908-06 for ; Mon, 30 Aug 2010 19:02:04 +0000 (UTC) X-Greylist: delayed 00:08:20.022099 by SQLgrey-1.7.6 Received: from smtp-vbr1.xs4all.nl (smtp-vbr1.xs4all.nl [194.109.24.21]) by mail.postgresql.org (Postfix) with ESMTP id 95B2663226D for ; Mon, 30 Aug 2010 16:02:04 -0300 (ADT) Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [82.95.228.65]) by smtp-vbr1.xs4all.nl (8.13.8/8.13.8) with ESMTP id o7UIrgxk039562 for ; Mon, 30 Aug 2010 20:53:42 +0200 (CEST) (envelope-from reinoud.v@n.leeuwen.net) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id 1717F1CC5A; Mon, 30 Aug 2010 20:30:00 +0200 (CEST) Date: Mon, 30 Aug 2010 20:30:00 +0200 From: Reinoud van Leeuwen To: pgsql-sql@postgresql.org Subject: Re: backup and document views and user functions Message-ID: <20100830182959.GK781@spoetnik.xs4all.nl> Mail-Followup-To: pgsql-sql@postgresql.org References: <4C7BF692.3030903@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4C7BF692.3030903@gmail.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: by XS4ALL Virus Scanner X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/87 X-Sequence-Number: 34527 On Mon, Aug 30, 2010 at 09:21:06PM +0300, David Harel wrote: > Hi, > > I am looking for an easy way to backup views and functions. I want to > store them in our version control system. > > Using pgAdmin I can access them one at a time. I am looking for a better > reporting mechanism. psql shell command for such report will be just fine. pg_dump? -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://reinoud.van.leeuwen.net kvk 27320762 __________________________________________________