Re: Create an empty copy of another table

I don't have time to test it out right now, but it
should be something like this:

SELECT * INTO tblTemp FROM tblExistingTable WHERE
nFieldOne = 5;

Look in the docs under SELECT INTO

David Boerwinkle
-----Original Message-----
From: Thomas Weholt <Thomas(at)cintra(dot)no>
To: 'pgsql-novice(at)postgresql(dot)org'
<pgsql-novice(at)postgresql(dot)org>
Date: Wednesday, June 28, 2000 9:29 AM
Subject: [NOVICE] Create an empty copy of another
table

>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