Hi, The table 'house' was created with the below code (partial) CREATE TABLE house ( house_id bigserial unique not null, phone bigint not null, address varchar(75) not null, primary key(phone, address) );My question is how can I switch the primary key from (phone, address) to house_id, now that the table is created and records have been inserted.
Thanks, C