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

Re: Create an empty copy of another table

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: Andrew McMillanDate: 2000-06-28 13:48:12
Subject: Re: Create an empty copy of another table
Previous:From: Thomas WeholtDate: 2000-06-28 11:47:02
Subject: Create an empty copy of another table

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