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

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

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.

David J.