view creation question

From: "Larry White" <ljw1001(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: view creation question
Date: 2006-03-09 15:55:12
Message-ID: d15ea14a0603090755r4dca0501lce83709e4c437529@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need a read only view that concatenates data from two tables. Basically
both tables would need a simple query like

Select name, description, date from Tasks;

Select name, description, date from Issues;

Is there some way to wrap these two independent queries in a "CREATE VIEW
myview AS" statement?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-03-09 16:02:52 Re: view creation question
Previous Message Merlin Moncure 2006-03-09 14:35:48 Re: Benchmark-Comparison PostGreSQL vs. SQL Server