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: (view raw or whole thread)
Lists: pgsql-novice

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.



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-2015 The PostgreSQL Global Development Group