X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2A3D8DA361 for ; Thu, 22 Sep 2005 05:37:38 -0300 (ADT) 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 81183-10 for ; Thu, 22 Sep 2005 08:37:33 +0000 (GMT) Received: from xrelay04.mail2web.com (xrelay04.mail2web.com [168.144.1.50]) by svr1.postgresql.org (Postfix) with ESMTP id 6A123DA202 for ; Thu, 22 Sep 2005 05:37:34 -0300 (ADT) Received: from [168.144.251.177] (helo=M2W068.mail2web.com) by xrelay04.mail2web.com with smtp (Exim 4.50) id 1EIMaA-0003WT-AV for pgsql-sql@postgresql.org; Thu, 22 Sep 2005 04:37:36 -0400 Message-ID: <380-22005942283730262@M2W068.mail2web.com> X-Priority: 3 Reply-To: lennie@corepat.com X-Originating-IP: 198.54.202.226 X-URL: http://mail2web.com/ From: "lennie@corepat.com" To: pgsql-sql@postgresql.org Date: Thu, 22 Sep 2005 04:37:30 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Subject: Copy Views From Database? X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.285 required=5 tests=[FORGED_RCVD_HELO=0.05, PRIORITY_NO_NAME=1.185, RCVD_IN_SBL=1.05] X-Spam-Level: ** X-Archive-Number: 200509/196 X-Sequence-Number: 22743 Hi Guys, I'm using PostGreSQL with a Java project since I'm a proffesional Java developer=2E I've a database that have about 120 views in PostGreSQL 7=2E0 that I need = to copy into PostGreSQL 8=2E0=2E I can copy them one-by-one in pgAdmin but I = don't have the time! Is there a maybe a tool that I can use to copy views as-is from one database into another=3F Kind Regards, Lennie De Villiers Java Developer CorePat Systems (Pty) Ltd www=2Ecorepat=2Ecom -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web=2Ecom/ =2E