Re: Update with a Repeating Sequence - Mailing list pgsql-general

alter table foo add newid sequencial;

alter table foo drop field_id;

alter table foo rename newid to field_id;