Create an empty copy of another table
Thomas Weholt <thomas@cintra.no>
From: Thomas Weholt <Thomas@cintra.no>
To: "'pgsql-novice@postgresql.org'" <pgsql-novice@postgresql.org>
Date: 2000-06-28T11:47:02Z
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