2 "id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
10 alter table tax add column id integer;
11 alter table tax alter column id set DEFAULT nextval('id'::text);
12 update tax set id=nextval('id');
14 insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, tax.id, taxkey_id, pos_ustva, '1970-01-01' from chart LEFT JOIN tax on (tax.taxkey=chart.taxkey_id) WHERE taxkey_id is not null;