Postgres Pro
Downloads
Home   >   mailing lists

Re: ​ERROR: syntax error at or near "collation" - Mailing list pgsql-admin

From David G. Johnston
Subject Re: ​ERROR: syntax error at or near "collation"
Date
Msg-id CAKFQuwbnktfh-VrPUwXeSV4woWUxMxxYeG633Ch-k-U7EaOP1Q@mail.gmail.com
Whole thread Raw
In response to Re: ​ERROR: syntax error at or near "collation"  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view


On Thursday, January 13, 2022, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thursday, January 13, 2022, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:

Hi All,

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


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


David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: ​ERROR: syntax error at or near "collation"
Next
From: Laurenz Albe
Date:
Subject: Re: database encoding and collation.