|
Well, I found a better way, but
still open to suggestions. This is what I have so far... create temporary table foo as
select * from maintable where 1-0; -- Credit 4 this goes to a post in the PG
archives insert into foo (select * from
maintable where primcol=123); update foo, set primcol=456; insert into maintable (select *
from foo); From:
pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On
Behalf Of Gauthier, Dave Hi: From within a perl/DBI script, I want to be able to make a
copy of a record in a table, changing only the value of the primary key.
I don't know in advance what all the columns are, just the table name. I suppose I could pull the column names for the table from
the metadata, query the table/record for the values to copy, build an insert
statement from all of that and run it. But is there a simpler, more
elegant way to do this? Thanks for any help ! |
