Hello !

I have a couple of tables with the same schema that I would like to
query and view as one table. I looked into CREATE VIEW and FULL JOINs
but still can't figure out a good (fast) way of doing this..

Any ideas ?

/Otto Blomqvist

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,
[color=blue]
> I have a couple of tables with the same schema that I would like to
> query and view as one table. I looked into CREATE VIEW and FULL JOINs
> but still can't figure out a good (fast) way of doing this..[/color]

It depends on the specific way you want to bring the tables together.
Without more specific information nobody will be able to help.

Somehow I suspect you are looking for UNION:

CREATE VIEW
bothTables
AS SELECT
x, y, z
FROM tableA
UNION SELECT
x, y, z
FROM tableB
;

Mit freundlichem Gruß / With kind regards
Holger Klawitter
- --
lists <at> klawitter <dot> de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFBJaMI1Xdt0HKSwgYRAkjQAJ95RawVA5ufaIaY1bITFH AvYsZWwACcCA0c
QKqsbAC1an/JIl/4Ok5mqLU=
=045v
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Do you mean

create view MyView as
select * from table1
union
select * from table2;

John Sidney-Woollett

Otto Blomqvist wrote:
[color=blue]
> Hello !
>
> I have a couple of tables with the same schema that I would like to
> query and view as one table. I looked into CREATE VIEW and FULL JOINs
> but still can't figure out a good (fast) way of doing this..
>
> Any ideas ?
>
> /Otto Blomqvist
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster[/color]

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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

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"


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings