Skip to content

Instantly share code, notes, and snippets.

@Sebdevar
Forked from scaryguy/change_primary_key.md
Created December 21, 2020 15:57
Show Gist options
  • Save Sebdevar/96a7b6b7543c5f5d5ca50b9ac24188f3 to your computer and use it in GitHub Desktop.
Save Sebdevar/96a7b6b7543c5f5d5ca50b9ac24188f3 to your computer and use it in GitHub Desktop.
How to change PRIMARY KEY of an existing PostgreSQL table?
-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;
-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;
-- Lastly set your new PRIMARY KEY
ALTER TABLE <table_name> ADD PRIMARY KEY (id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment