Skip to content

Instantly share code, notes, and snippets.

@felipe3dfx
Last active June 1, 2020 22:34
Show Gist options
  • Save felipe3dfx/13f6c93ab1071e214258005534efb833 to your computer and use it in GitHub Desktop.
Save felipe3dfx/13f6c93ab1071e214258005534efb833 to your computer and use it in GitHub Desktop.
Crear setval en postgres
create sequence enrollment_enrollmentcompany_id_seq;
select max(id) from enrollment_enrollmentcompany;
select setval('enrollment_enrollmentcompany_id_seq', 609, true);
alter table enrollment_enrollmentcompany alter column id set default nextval('enrollment_enrollmentcompany_id_seq');
-- Option 2
CREATE sequence enrollment_enrollmentcompany_id_seq owned by enrollment_enrollmentcompany.id;
SELECT setval(pg_get_serial_sequence('"enrollment_enrollmentcompany"','id'), coalesce(max("id"), 1), max("id") IS NOT null) FROM "enrollment_enrollmentcompany";
ALTER TABLE "enrollment_enrollmentcompany" ALTER COLUMN "id" SET DEFAULT nextval(pg_get_serial_sequence('"enrollment_enrollmentcompany"','id'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment