postgres column "X" does not exist

Question

I have this postgrse code:

CREATE TABLE IF NOT EXISTS config_change_log
(
  id                    serial primary key,
  last_config_version   varchar(255) NOT NULL,
  is_done               Boolean NOT NULL DEFAULT '0',
  change_description     varchar(255),
  timestamp timestamp   default current_timestamp
);

INSERT INTO config_change_log(last_config_version, is_done, change_description )
VALUES("5837-2016-08-24_09-12-22", false, "{ 'key':'value'}");

and I get this error:

psql:createConfigChangeLog.sql:11: ERROR:  column "5837-2016-08-24_09-12-22" does not exist
LINE 2: VALUES("5837-2016-08-24_09-12-22", false, "{ 'key':'value'}"...

how can it be? it's a value not a column.postgr

Use single quotes, rather than double quotes.

Gordon Linoff
– Gordon Linoff

2016-09-13 15:43:37 +00:00
Commented Sep 13, 2016 at 15:43 — Gordon Linoff
– Gordon Linoff, Commented Sep 13, 2016 at 15:43

Pரதீப் · Accepted Answer · 2016-09-13 15:43:49Z

5

Use single quotes for string constants

INSERT INTO config_change_log(last_config_version, is_done, change_description )
VALUES('5837-2016-08-24_09-12-22', false, '{ ''key'':''value''}');

Also you can escape single quotes in data by doubling them

SQL FIDDLE DEMO

answered Sep 13, 2016 at 15:43

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

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

Collectives™ on Stack Overflow

postgres column "X" does not exist

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related