insert rowtype - Mailing list pgsql-sql

From Bryan Klimt
Subject insert rowtype
Date
Msg-id 071B599C-80FC-11D7-831B-000A95774E48@baylor.edu
Whole thread Raw
List pgsql-sql
In a plpgsql function, I have a variable of type table%rowtype
I populate the row by calling "select into <variable> * from <table>"
then i change some stuff like "<variable>.<field> := <new value>"
now i want to insert the row into the table as a new row - is there an 
easy way to do this?

i know i could do "insert into <table> values ( <variable>.<field 1>, 
<variable>.<field 2>, ... );"
but that is a lot of typing, and it seems like there should be an 
easier way.

-Bryan



pgsql-sql by date:

Previous
From: Bernd von den Brincken
Date:
Subject: Re: [BUGS] An unresolved performance problem.
Next
From: "J Sensel"
Date:
Subject: Looking for script to dump postgresql schema to xml file