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