#title Clone records with serial key
#author Stefan Hornburg (Racke)
#topics blog; PostgreSQL
#date 2009-01-08
#pubdate 2009-01-08T09:43:31+01:00
#lang en



<example>

insert into form_elements(code,name,label,component,widget) select nextval('form_elements_code_seq'),name,label,'register',widget from form_elements where component = 'shippingaddress';

</example>