Postgres Pro
Downloads
Home   >   mailing lists

view creation question - Mailing list pgsql-general

From Larry White
Subject view creation question
Date
Msg-id d15ea14a0603090755r4dca0501lce83709e4c437529@mail.gmail.com
Whole thread Raw
Responses Re: view creation question  (Michael Fuhr <mike@fuhr.org>)
Re: view creation question  (Michael Glaesemann <grzm@myrealbox.com>)
Re: view creation question  (Richard Huxton <dev@archonet.com>)
Re: view creation question  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Tree view
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?


pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Benchmark-Comparison PostGreSQL vs. SQL Server
Next
From: Michael Fuhr
Date:
Subject: Re: view creation question