Last active
June 1, 2020 22:34
-
-
Save felipe3dfx/13f6c93ab1071e214258005534efb833 to your computer and use it in GitHub Desktop.
Crear setval en postgres
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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