Re: Drop a primary

Ron <ronljohnsonjr@xxxxxxxxx> · Wed, 2 Oct 2019 13:52:54 -0500



    On 10/2/19 1:48 PM, Martin Mueller wrote:

    
        I created a
            primary key with the following commands
         
        Add id
            serial
        Add primary
            key (id)
         
        I cannot
            figure out from the documentation how to drop that column.
          
      
    Drop it just like you added it:

    
    test=# alter table foobar add id serial;

    ALTER TABLE

    test=# alter table foobar add primary key(id);

    ALTER TABLE

    test=# alter table foobar drop id;

    ALTER TABLE

    
    -- 

      Angular momentum makes the world go 'round.