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 CAKFQuwYr+=rc30UmfTzy-L0yzPPh2Yb6rXpby4i0KMACo3+_AQ@mail.gmail.com
Whole thread Raw
In response to ​ERROR: syntax error at or near "collation"  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Responses 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, 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.

David J.
 

pgsql-admin by date:

Previous
From: dbatoCloud Solution
Date:
Subject: ​ERROR: syntax error at or near "collation"
Next
From: "David G. Johnston"
Date:
Subject: Re: ​ERROR: syntax error at or near "collation"