I have a table named email_recipients
and an ID
is skipped whenever there is a duplicate in email
.
CREATE TABLE email_recipients(
id SERIAL PRIMARY KEY,
email_address varchar(255) UNIQUE NOT NULL,
last_name varchar(255),
first_name varchar(255),
active boolean
);