Re: CREATE VIEW form stored in database?

From: George Weaver <gweaver(at)shaw(dot)ca>
To: mario(dot)splivalo(at)mobart(dot)hr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: CREATE VIEW form stored in database?
Date: 2006-02-13 17:33:39
Message-ID: 007701c630c3$a40477b0$6400a8c0@Dell4500
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


----- Original Message -----
From: "Mario Splivalo" <mario(dot)splivalo(at)mobart(dot)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(dot)splivalo(at)mobart(dot)hr
>
> "I can do it quick, I can do it cheap, I can do it well. Pick any two."
>
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2006-02-13 19:19:30 Problems with distinct
Previous Message Alfred 2006-02-13 17:33:01 Tough Problem -- Record Checkouts