I am trying to insert the following value
('PA', 'Hilda Blainwood', 3, 10.7, 4308.20, '9/8/1974', '9:00', '07/03/1996 10:30:00');
to the alltypes table with the following structure
create table alltypes( state CHAR(2), name CHAR(30), children INTEGER, distance FLOAT, budget NUMERIC(16,2), checkin TIME, started TIMESTAMP);
the following error appears
test=# insert into alltypes VALUES('PA', 'Hilda Blainwood', 3, 10.7, 4308.20, '9/8/1974', '9:00', '07/03/1996 10:30:00'); ERROR: INSERT has more expressions than target columns LINE 1: ...Blainwood', 3, 10.7, 4308.20, '9/8/1974', '9:00', '07/03/199...