Thomas Weholt wrote:
> 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.
CREATE TABLE t2 AS SELECT * FROM t1;
There are other ways. You mission is to learn those as well :-)
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
In response to
pgsql-novice by date
|Next:||From: Andrew McMillan||Date: 2000-06-28 13:48:12|
|Subject: Re: Create an empty copy of another table|
|Previous:||From: Thomas Weholt||Date: 2000-06-28 11:47:02|
|Subject: Create an empty copy of another table|