Обсуждение: ERROR: syntax error at or near "collation"
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)
Thanks
Ashok
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ashokkumar Mani
+91 81975 99922
W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com
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)
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:4
8: ERROR: syntax error at or near "collation" LINE 37: collation varchar(100)
Don’t use reserved words as column names.