Re: [GENERAL] temporary tables

hi,
I commonly use COPY to import txt files to pg tables. You can use a simple
statement as :

insert into permanent_table select * from template_table ;

This will append the new rows to the existing ones in the permanent table.

hope that helps
Omid Omoomi


>From: "sheila bel" <sheilabel@hotmail.com>
>To: pgsql-general@postgreSQL.org
>Subject: [GENERAL] temporary tables
>Date: Wed, 16 Feb 2000 15:42:21 GMT
>
>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
>
>
>************
>

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