From: | Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Thomas Weholt <Thomas(at)cintra(dot)no> |
Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Create an empty copy of another table |
Date: | 2000-06-28 13:41:55 |
Message-ID: | 395A00A3.35099900@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thomas Weholt wrote:
>
> Hi,
>
> How do I create a new empty table that`s a copy of an allready existing one?
> I need a way of putting the result of a select-statement into a temporary
> table that`s an exact copy of the table it`s derived from and I`m not sure
> how to do this. Obviously. I am just using one table to query at the time.
>
> Thomas
CREATE TABLE t2 AS SELECT * FROM t1;
There are other ways. You mission is to learn those as well :-)
Cheers,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2000-06-28 13:48:12 | Re: Create an empty copy of another table |
Previous Message | Thomas Weholt | 2000-06-28 11:47:02 | Create an empty copy of another table |