Skip site navigation (1) Skip section navigation (2)

Re: How do I create a new table based on combining a number of tables

From: Serge Fonville <serge(dot)fonville(at)gmail(dot)com>
To: Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How do I create a new table based on combining a number of tables
Date: 2009-09-28 08:04:10
Message-ID: 680cbe0e0909280104u67bc6d5cj8d372a370f347391@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,
Both can do the job

Use a union
http://www.postgresql.org/docs/8.4/interactive/queries-union.html.

HTH

Regards,

Serge Fonville

On Mon, Sep 28, 2009 at 9:59 AM, Intengu Technologies <
sindile(dot)bidla(at)gmail(dot)com> wrote:

> Hi List
>
> I have a number of tables that I would want to combine (append one
> table to another) into a single table. What would be the best approach
> and how do I write the corresponding sql statement:
>
> 1. Create a new table
>
> 2. Create a view
>
> --
> Sindile Bidla
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>



-- 
Convince Google!!
They need to support Adsense over SSL
https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528
http://www.google.com/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en

In response to

Responses

pgsql-novice by date

Next:From: Intengu TechnologiesDate: 2009-09-28 10:00:37
Subject: Re: How do I create a new table based on combining a number of tables
Previous:From: Intengu TechnologiesDate: 2009-09-28 07:59:55
Subject: How do I create a new table based on combining a number of tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group