Thread: temporary tables

Hi everyone,

I'm trying to create a temporary table, store some data
in it then after a while copy the data into another table
and drop the temporary. I'm not sure exactly how this is
done. I went to Mr. Momjian's Manual before posting this
question and found the title of temporary tables at:
http://www.postgresql.org/docs/aw_pgsql_book/node148.html
but I was disappointed to find nothing in there.
Reminded me of when I was looking for info about primary
keys.

For copying data from one table to another I did check
out the COPY command of SQL commands but there wasn't a
clear example to show how it is exactly done from one
table to another. I'm sorry if my question is so basic,
I'm just finding it difficult to find information
specially without a book.

The data that needs to be copied is either text or password.
This is what I think should be done please correct me if
its wrong :
COPY temptable(attributes) To permanent_table(attributes);

If someone could give me an example I would really appreciate
it.

-Sheila
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

sheila bel wrote:
>
> Hi everyone,
>
> The data that needs to be copied is either text or password.
> This is what I think should be done please correct me if
> its wrong :
> COPY temptable(attributes) To permanent_table(attributes);
>
> If someone could give me an example I would really appreciate
> it.
>
> -Sheila

INSERT INTO permanent_table SELECT * from temptable;

Hope that helps,

Mike Mascari

> Hi everyone,
>
> I'm trying to create a temporary table, store some data
> in it then after a while copy the data into another table
> and drop the temporary. I'm not sure exactly how this is
> done. I went to Mr. Momjian's Manual before posting this
> question and found the title of temporary tables at:
> http://www.postgresql.org/docs/aw_pgsql_book/node148.html
> but I was disappointed to find nothing in there.
> Reminded me of when I was looking for info about primary
> keys.

See chapter 8 on combining selects:

SELECT * INTO TEMP newtable FROM oldtable.


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026