pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: George Weaver <gweaver@shaw.ca>
To: mario.splivalo@mobart.hr
Cc: pgsql-sql@postgresql.org
Subject: Re: CREATE VIEW form stored in database?
Date: Mon, 13 Feb 2006 11:33:39 -0600
Message-ID: <007701c630c3$a40477b0$6400a8c0@Dell4500> (raw)
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>


----- Original Message ----- 
From: "Mario Splivalo" <mario.splivalo@mobart.hr>

>> 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."
>
>
> 





view thread (5+ messages)

Message-ID: <007701c630c3$a40477b0$6400a8c0@Dell4500>
Permalink:  ../007701c630c3$a40477b0$6400a8c0@Dell4500/
Also on:    postgresql.org/message-id/007701c630c3$a40477b0$6400a8c0@Dell4500

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: gweaver@shaw.ca, mario.splivalo@mobart.hr
  Subject: Re: CREATE VIEW form stored in database?
  In-Reply-To: <007701c630c3$a40477b0$6400a8c0@Dell4500>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox