Re: ​ERROR: syntax error at or near "collation"

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thursday, January 13, 2022, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Thursday, January 13, 2022, dbatoCloud Solution <dbatocloud17@xxxxxxxxx> wrote:

Hi All,

I am getting the below error while executing sql file in postgresql ? Can somebody suggest plz?

SET

psql:comsod_db_structure.sql:48: ERROR:  syntax error at or near "collation"

LINE 37:  collation varchar(100)

Don’t use reserved words as column names.

Precisely…the word being complained about, “collation”, is reserved [1].  Rename the column or double-quote it.

[1] https://www.postgresql.org/docs/current/sql-keywords-appendix.html

David J.