Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 80152634129
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 14 May 2009 11:37:47 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 96933-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 14 May 2009 11:37:35 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from perseverance.services.encs.concordia.ca
	(perseverance-96.encs.concordia.ca [132.205.96.94])
	by mail.postgresql.org (Postfix) with ESMTP id 9C005634109
	for <pgsql-sql@postgresql.org>; Thu, 14 May 2009 11:37:44 -0300 (ADT)
Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca
	[132.205.47.225])
	by perseverance.services.encs.concordia.ca (envelope-from
	emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id n4EEbgGJ020827
	for <pgsql-sql@postgresql.org>; Thu, 14 May 2009 10:37:42 -0400
Message-ID: <4A0C2CB5.6060707@encs.concordia.ca>
Date: Thu, 14 May 2009 10:37:41 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Thunderbird 2.0.0.21 (X11/20090302)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: How to dump views definition in one schema?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.58 on perseverance.encs.concordia.ca at 2009/05/14
	10:37:42 EDT
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200905/66
X-Sequence-Number: 32558

Good morning,

Can pg_dump or other command could dump all views definition in one schema.

I was trying to alter column types for several tables, and I have very 
complicated view dependencies.

What I try to do is:
(1). Back all views def
(2). alter columns
(3). re-create views from (1)

I'd like to know how to dump all views in one schema?

Thanks,

--
Lu Ying