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 7C6D99DCC87 for ; Tue, 31 Jan 2006 10:51:59 -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 73463-02 for ; Tue, 31 Jan 2006 10:52:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pd7mo4no.prod.shaw.ca (idcmail-mo2no.cg.shawcable.net [64.59.134.9]) by postgresql.org (Postfix) with ESMTP id D1C5E9DCBE4 for ; Tue, 31 Jan 2006 10:51:56 -0400 (AST) Received: from pd8mr6no.prod.shaw.ca (pd8mr6no-qfe2.prod.shaw.ca [10.0.144.227]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ITY00IHRPAMM590@l-daemon> for pgsql-sql@postgresql.org; Tue, 31 Jan 2006 07:51:58 -0700 (MST) Received: from pn7ml2no.prod.shaw.ca ([10.0.149.111]) by pd8mr6no.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ITY008WGPAMRVA0@pd8mr6no.prod.shaw.ca> for pgsql-sql@postgresql.org; Tue, 31 Jan 2006 07:51:58 -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 <0ITY00D1TPAHSD50@l-daemon> for pgsql-sql@postgresql.org; Tue, 31 Jan 2006 07:51:58 -0700 (MST) Date: Tue, 31 Jan 2006 08:53:13 -0600 From: George Weaver Subject: Re: CREATE VIEW form stored in database? To: mario.splivalo@mobart.hr Cc: pgsql-sql@postgresql.org Message-id: <004801c62676$12063170$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> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.079 required=5 tests=[AWL=-0.840, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.079 X-Spam-Level: * X-Archive-Number: 200601/219 X-Sequence-Number: 24008 ----- Original Message ----- From: "Mario Splivalo" > > Yes, I'm tied to the pgadmin3 for the moment, so there's nothing I could > do. It's a pain to develop a database such way. Mario, 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. Regards, George