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

Create an empty copy of another table

From: Thomas Weholt <Thomas(at)cintra(dot)no>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Create an empty copy of another table
Date: 2000-06-28 11:47:02
Message-ID: 01EEE08EC217D311B67400105AC8AB0E088909@ns1.cintra.no (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Andrew McMillanDate: 2000-06-28 13:41:55
Subject: Re: Create an empty copy of another table
Previous:From: Stuart UrbanDate: 2000-06-28 03:22:38
Subject: gmake command not working

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