CREATE TABLE tblproject ( ProjectCode serial PRIMARY KEY, ProjectName VARCHAR (100) NOT NULL, ProjectDt DATE NOT NULL, Cost Numeric (12,2), PCCode VARCHAR(50) NOT NULL ); INSERT INTO tblproject (ProjectName, ProjectDt, Cost, PCCode) VALUES ('A', '2017-06-19', 10000, '1,2,3,4'), ('B', '2017-07-10', 20000, '5'), ('C', '2017-10-24', 50000, '6,4');