hanula · December 4, 2024 08:56
diff --git a/Postgres duplicate row.sql b/Postgres duplicate row.sql
 INSERT INTO xxx 
 SELECT (
 f 
 #= hstore('id', nextval(pg_get_serial_sequence('xxx', 'id'))::text) 
 #= hstore('somefield', 'value')
 ).* FROM xxx f WHERE id=XXX;
	INSERT INTO xxx
	SELECT (
	f
	#= hstore('id', nextval(pg_get_serial_sequence('xxx', 'id'))::text)
	#= hstore('somefield', 'value')
	).* FROM xxx f WHERE id=XXX;