Olivier Adam oadam

## change_primary_key.md

      
              1 file
            
          
              30 forks
            
          
              35 comments
            
          
              216 stars
            
          
                scaryguy
                / change_primary_key.md
            
            
              Last active
              June 9, 2024 22:58
            
              
                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;

  
## pedantically_commented_playbook.yml
This playbook has been removed as it is now very outdated.