copy rows

From: drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu
To: pgsql-sql(at)postgresql(dot)org
Subject: copy rows
Date: 2005-02-09 07:53:39
Message-ID: Pine.LNX.4.61.0502090849260.16831@mazsola.iit.uni-miskolc.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

What is the simplest solution in plpgsql to copy some rows in a table?

I would like to do something like:

select some rows
do for each row
skip serial field \
modify one field |-- what is the simplest way for this?
insert as new row /

Is it possible to insert a record type variable? If yes, how to skip a
field?

Daniel

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-02-09 11:01:31 parsing a string with a hexadecimal notation
Previous Message Michael Fuhr 2005-02-09 07:31:35 Re: Maximum length of a query