Re: making two tables with identical schemas appear as - Mailing list pgsql-general

On Fri, Aug 20, 2004 at 10:40:43AM +0100, John Sidney-Woollett wrote:
> Do you mean
>
> create view MyView as
> select * from table1
> union
> select * from table2;

Be sure to understand the difference between UNION and UNION ALL if you
are going to do this ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No reniegues de lo que alguna vez creíste"