X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 827359DC848 for ; Mon, 13 Feb 2006 13:33:35 -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 73705-03 for ; Mon, 13 Feb 2006 13:33:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pd8mo4no.prod.shaw.ca (idcmail-mo2no.cg.shawcable.net [64.59.134.9]) by postgresql.org (Postfix) with ESMTP id 0539E9DC846 for ; Mon, 13 Feb 2006 13:33:32 -0400 (AST) Received: from pd8mr5no.prod.shaw.ca (pd8mr5no-qfe2.prod.shaw.ca [10.0.144.226]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0IUM00KTGZFWSK10@l-daemon> for pgsql-sql@postgresql.org; Mon, 13 Feb 2006 10:33:33 -0700 (MST) Received: from pn7ml2no.prod.shaw.ca ([10.0.149.111]) by pd8mr5no.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0IUM00A0YZFW5HB0@pd8mr5no.prod.shaw.ca> for pgsql-sql@postgresql.org; Mon, 13 Feb 2006 10:33:32 -0700 (MST) Received: from Dell4500 ([24.77.157.242]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with SMTP id <0IUM00630ZFPWND0@l-daemon> for pgsql-sql@postgresql.org; Mon, 13 Feb 2006 10:33:32 -0700 (MST) Date: Mon, 13 Feb 2006 11:33:39 -0600 From: George Weaver Subject: Re: CREATE VIEW form stored in database? To: mario.splivalo@mobart.hr Cc: pgsql-sql@postgresql.org Message-id: <007701c630c3$a40477b0$6400a8c0@Dell4500> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Mailer: Microsoft Outlook Express 6.00.2900.2670 Content-type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Content-transfer-encoding: 7bit X-Priority: 3 X-MSMail-priority: Normal References: <1138701111.8587.3.camel@localhost.localdomain> <43DF586C.1070009@archonet.com> <1138715614.8587.5.camel@localhost.localdomain> <004801c62676$12063170$6400a8c0@Dell4500> <1139844994.13054.25.camel@localhost.localdomain> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.319 required=5 tests=[AWL=-0.600, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.319 X-Spam-Level: * X-Archive-Number: 200602/137 X-Sequence-Number: 24147 ----- Original Message ----- From: "Mario Splivalo" >> If you keep your definition in a script file, you can copy the script and >> paste it into pgAdmin's Execute Arbitrary SQL Queries window, and then >> execute the script from there. >> > > It's still a pain. If I have two dozen views, it takes too much time :) You also have the option of loading script files in the Execute Arbitray SQL Queries window (File > Open, etc.). Thus you could put all your views into one script file, load the file, and then execute the query. > > Mario > -- > Mario Splivalo > Mob-Art > mario.splivalo@mobart.hr > > "I can do it quick, I can do it cheap, I can do it well. Pick any two." > > >