dreadedhamish

## change_primary_key.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                dreadedhamish
                / change_primary_key.md
            
            
              Created
              October 29, 2022 11:47
                — forked from scaryguy/change_primary_key.md
            
              
                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;