Request a Demo
Home   >   mailing lists

view creation question - Mailing list pgsql-general

From Larry White
Subject view creation question
Date
Msg-id [email protected]
Whole thread Raw
Responses Re: view creation question
Re: view creation question
Re: view creation question
Re: view creation question
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