Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id BDB4863226D
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 30 Aug 2010 15:21:20 -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 54274-05 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 30 Aug 2010 18:21:13 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ew0-f46.google.com (mail-ew0-f46.google.com
	[209.85.215.46])
	by mail.postgresql.org (Postfix) with ESMTP id 2ADA6633031
	for <pgsql-sql@postgresql.org>; Mon, 30 Aug 2010 15:21:12 -0300 (ADT)
Received: by ewy23 with SMTP id 23so3381944ewy.19
	for <pgsql-sql@postgresql.org>; Mon, 30 Aug 2010 11:21:11 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:subject:content-type;
	bh=f97TFxK39PRkzrL1MN970ssN2DFHbA80v0HYS8Er9oY=;
	b=jDR42gQ1rxEwFZxFq+G8elQaqXdDrW3HfxxmSvReW8xyCfakv+VxViyfL1Q3N969vD
	aoYWEWcV28FI1YoWGeadWTknrkEKb1Nb4Nv5bp2gmjSswNHiV3lgGAxQVapMvsrthxIO
	kGTanrLiQNFgRFuQ8ZmU28uVAGvAmFhCIzNi0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type;
	b=h6Llfb7xmUUa7a1Td3vkxkaCEyE+vXI3kpzV19UT0GfDNWLaOK519BJloiKF/Y9mQq
	cS6vTzcD65LWiJNP0tIDK+ZQAZISedi1k6kHy6wQFAhInLHgrxHW1yhwpNhPpL4wh/Fw
	nlLD8FQznDddlB1ei8cHhuiP/lWWw80dGXgH0=
Received: by 10.213.31.79 with SMTP id x15mr8732545ebc.60.1283192471547;
	Mon, 30 Aug 2010 11:21:11 -0700 (PDT)
Received: from [10.0.0.19] ([109.66.34.85])
	by mx.google.com with ESMTPS id a48sm12490224eei.1.2010.08.30.11.21.08
	(version=SSLv3 cipher=RC4-MD5); Mon, 30 Aug 2010 11:21:10 -0700 (PDT)
Message-ID: <4C7BF692.3030903@gmail.com>
Date: Mon, 30 Aug 2010 21:21:06 +0300
From: David Harel <hareldvd@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.11) Gecko/20100713 Thunderbird/3.0.6
MIME-Version: 1.0
To: postgres sql <pgsql-sql@postgresql.org>
Subject: backup and document views and user functions
Content-Type: multipart/alternative;
	boundary="------------090802050708000406040801"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.889 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	T_FILL_THIS_FORM_SHORT=0.01
X-Spam-Level: 
X-Archive-Number: 201008/84
X-Sequence-Number: 34524

This is a multi-part message in MIME format.
--------------090802050708000406040801
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.

Sorry for the lame question. I didn't find any clues on the web 
.(typically, I fail to phrase the right keywords)

-- 
Thanks.

David Harel,

==================================

Home office +972 77 7657645
Cellular:   +972 54 4534502
Snail Mail: Amuka
             D.N Merom Hagalil
             13802
             Israel
Email:      hareldvd@ergolight-sw.com



--------------090802050708000406040801
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body style="direction: ltr;" text="#000000" bgcolor="#ffffff">
<font size="+1"><font face="Arial">Hi,<br>
<br>
I am looking for an easy way to backup views and functions. I want to
store them in our version control system.<br>
<br>
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.<br>
<br>
Sorry for the lame question. I didn't find any clues on the web
.(typically, I fail to phrase the right keywords)<br>
</font></font>
<pre class="moz-signature" cols="72">-- 
Thanks.

David Harel,

==================================

Home office +972 77 7657645
Cellular:   +972 54 4534502
Snail Mail: Amuka
            D.N Merom Hagalil
            13802
            Israel
Email:      <a class="moz-txt-link-abbreviated" href="mailto:hareldvd@ergolight-sw.com">hareldvd@ergolight-sw.com</a>

</pre>
</body>
</html>

--------------090802050708000406040801--