Skip to content

Instantly share code, notes, and snippets.

@juelvaldivia

juelvaldivia/Crear incrementable table postgresql

Last active October 1, 2019 19:54
Show Gist options
  • Save juelvaldivia/0c8449fe1a97f8b04ccec0b27f3d2963 to your computer and use it in GitHub Desktop.
Save juelvaldivia/0c8449fe1a97f8b04ccec0b27f3d2963 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Crear incrementable table postgresql
create sequence table_id_table_seq;
ALTER TABLE public.table ALTER COLUMN id_table SET DEFAULT nextval('"table_id_table_seq"'::regclass);
alter sequence table_id_table_seq
owner by table.id_table;
// valor por defecto en autoincrementable
ALTER SEQUENCE table_id_table_seq RESTART WITH 4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment