Re: [GENERAL] copying from one table to another - Mailing list pgsql-general

>>>>> "OW" == Omega Weapon <weapon_77@yahoo.com> writes:

 OW> I have two identical tables -- section and
 OW> temp_section.  I use the section table for keeping
 OW> original values and temp_section for editing.

 OW> How do I copy the values from temp_section to section?

begin;

delete from section;
insert into section select * from temp_section;

commit;