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

From: Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: How do I create a new table based on combining a number of tables
Date: 2009-09-28 07:59:55
Message-ID: a1afa64b0909280059g1edfc252gf0b19857274ae28b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Serge Fonville 2009-09-28 08:04:10 Re: How do I create a new table based on combining a number of tables
Previous Message Nicholas Slabosz 2009-09-28 06:45:56 get current function name