Re: making two tables with identical schemas appear as

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
Cc: Otto Blomqvist <o(dot)blomqvist(at)secomintl(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: making two tables with identical schemas appear as
Date: 2004-08-20 14:08:20
Message-ID: 20040820140820.GA5280@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jerry LeVan 2004-08-20 14:14:11 ANN:BiggerSQL-1.3.5 released. MultiMedia Aware
Previous Message Jeff Eckermann 2004-08-20 13:47:24 Re: need help with copy function