syntax error at or near column name while trying insert sql dump

Question

I am trying to insert a table specific sql dump into a database (psql). There is a table called "templates" which already has some values, and trying to dump new values. The sql file looks like below.

INSERT INTO templates (id, name, created_at, updated_at, template_path, page_type, container_type, entity_type, entity_id, asset_group_id, data_proxy_id, publisher_id, status, default, image_url_path, sequence) VALUES ('434', 'Full Width Image', '2018-10-25 11:13:35.695256', '2018-11-23 07:26:25.663427', '/templates/full_width_landscape', null, null, null, null, null, null, '655', 'true', 'true', 'template1', 1);

When I am trying to insert this sql file by doing

\i sql file path

I am getting the following error:

ERROR:  syntax error at or near "default"
LINE 1: ...et_group_id, data_proxy_id, publisher_id, status, default, i...

Can someone tell what's wrong here ?

default is a reserved word in SQL. Use "default" instead, i.e. a delimited identifier. — jarlh
– jarlh, Commented Nov 23, 2018 at 9:58
default is a reserved word in SQL. Use a different name, so you don't have conflicts with reserved words. — Gordon Linoff
– Gordon Linoff, Commented Nov 23, 2018 at 12:27

Zaynul Abadin Tuhin · Accepted Answer · 2018-11-23 09:58:31Z

1

you have use use double quote for reserve word as a column name

    INSERT INTO templates (id, name, created_at, updated_at,
 template_path, page_type, container_type,
 entity_type, entity_id, asset_group_id, 
data_proxy_id, publisher_id, status, "default", 
image_url_path, sequence) VALUES ('434', 'Full Width Image', '2018-10-25 11:13:35.695256', '2018-11-23 07:26:25.663427', '/templates/full_width_landscape', null, null, null, null, null, null, '655', 'true', 'true', 'template1', 1);

answered Nov 23, 2018 at 9:58

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

syntax error at or near column name while trying insert sql dump

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