CREATE TABLE client( client_id serial NOT NULL PRIMARY KEY, username varchar(64), domain varchar(64), customer_name varchar(64)); CREATE INDEX IDX_client_1 ON client (username); CREATE INDEX IDX_client_2 ON client (domain);