Error when I try to insert a timestamp value in PostgreSQL?

Question

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');

into table alltypes 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 pops up

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...

mu is too short · Accepted Answer · 2012-09-12 04:09:38Z

5

The error message is pretty self explanatory: you're trying to insert more values that the table has columns. Your table has seven columns but your VALUES expression has eight values.

BTW, you should always specify the columns when you INSERT:

insert into alltypes (state, name, children, distance, budget, checkin, started)
values (...)

answered Sep 12, 2012 at 4:09

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error when I try to insert a timestamp value in PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related