Temp Table

From: Bob Pawley <rjpawley(at)shaw(dot)ca>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Temp Table
Date: 2007-10-19 16:39:20
Message-ID: 009b01c8126e$9b539db0$6401a8c0@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I fetch a row, as in the following, how do I copy the row's data into a temporary table so that I can process it??

begin work;
Declare loop_set Cursor
for Select one, two, three, four, five, six, seven from loop_import
order by loop_id ;
fetch next From loop_set;

Bob Pawley

Responses

Browse pgsql-general by date

  From Date Subject
Next Message smiley2211 2007-10-19 16:44:30 Generating sql to capture fully qualified table names???
Previous Message Stephane Bortzmeyer 2007-10-19 16:25:43 Re: running postgres