Create an empty copy of another table - Mailing list pgsql-novice

From Thomas Weholt
Subject Create an empty copy of another table
Date
Msg-id 01EEE08EC217D311B67400105AC8AB0E088909@ns1.cintra.no
Whole thread Raw
List 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

pgsql-novice by date:

Previous
From: Stuart Urban
Date:
Subject: gmake command not working
Next
From: Andrew McMillan
Date:
Subject: Re: Create an empty copy of another table