Skip to content

Instantly share code, notes, and snippets.

@makaroni4

makaroni4/add serial primary key to existing table.sql

Created April 7, 2016 13:34
Show Gist options
  • Save makaroni4/8600ce51e583990c8e52c39d841ecadb to your computer and use it in GitHub Desktop.
Save makaroni4/8600ce51e583990c8e52c39d841ecadb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
add serial primary key to existing table.sql
ALTER TABLE mc_subscribers ADD COLUMN id BIGSERIAL;
UPDATE mc_subscribers SET id = nextval(pg_get_serial_sequence('mc_subscribers', 'id'));
ALTER TABLE mc_subscribers ADD PRIMARY KEY (id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment