[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    =?UTF-8?Q?=E2=80=8BERROR=3A_syntax_error_at_or_near_=22collation=22?=
From:       dbatoCloud Solution <dbatocloud17 () gmail ! com>
Date:       2022-01-14 3:40:56
Message-ID: CAEz7P_v7Qh2HMkEL+2_UuGAWNzDJjEfzgY5+RGsCYZ20S=YPAA () mail ! gmail ! com
[Download RAW message or body]

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)


Thanks

Ashok

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ashokkumar Mani

 +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/
<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17@gmail.com

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_default" \
style="font-family:georgia,serif;font-size:small;color:#073763"><br \
clear="all"></div><div><div dir="ltr" class="gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><p class="MsoNormal"><font \
face="Arial" color="#0c343d">Hi<span class="gmail_default" \
style="font-family:georgia,serif;font-size:small;color:rgb(7,55,99)"> \
All,</span></font></p><p class="MsoNormal"><font face="Arial" color="#0c343d"><span \
class="gmail_default" \
style="font-family:georgia,serif;font-size:small;color:rgb(7,55,99)">I am getting the \
below error while executing sql file in postgresql ?  Can somebody suggest \
plz?</span></font></p><p class="MsoNormal"><font face="Arial" \
color="#0c343d"><br></font></p><p class="MsoNormal"><font face="Arial" \
color="#0c343d"><span class="gmail_default" \
style="font-family:georgia,serif;font-size:small;color:rgb(7,55,99)"></span></font>SET</p>psql:comsod_db_structure.sql:48: \
<span class="gmail_default" \
style="font-family:georgia,serif;font-size:small;color:rgb(7,55,99)"></span>ERROR:   \
syntax error at or near &quot;collation&quot;<br><p class="MsoNormal">LINE 37:   \
collation varchar(100)<font face="Arial" color="#0c343d"><span class="gmail_default" \
style="font-family:georgia,serif;font-size:small;color:rgb(7,55,99)"></span><br></font></p><p \
class="MsoNormal"><font face="Arial" color="#0c343d"><br></font></p><p \
class="MsoNormal"><font face="Arial" color="#0c343d">Thanks</font></p><p \
class="MsoNormal"><font face="Arial" color="#0c343d">Ashok</font></p><p \
class="MsoNormal"><font face="Arial" \
color="#0c343d">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</font></p><p \
class="MsoNormal"><font face="Arial" color="#0c343d" size="1">Ashokkumar \
Mani</font></p><p class="MsoNormal"><font color="#0c343d" face="Arial" size="1">  \
</font><font color="#0c343d" face="Arial" size="1">+91 81975 99922  </font><br></p><p \
class="MsoNormal"><font face="garamond, times new roman, serif"><span \
style="font-size:7.5pt"><span style="font-size:small;color:rgb(7,55,99)"></span>W: \
</span><span style="font-size:8pt;color:rgb(51,51,51)"><a \
href="http://dbatocloudsolution.blogspot.in/" target="_blank"><span \
style="font-size:small;color:rgb(7,55,99)"></span>https://dbatocloudsolution.blogspot.in/</a>
 </span><span style="font-size:7.5pt">| E: <a href="mailto:dbatocloud17@gmail.com" \
target="_blank">dbatocloud17@gmail.com</a></span></font><span \
style="color:rgb(12,52,61);font-family:Arial;font-size:x-small"><br></span></p><p \
class="MsoNormal"><span \
style="color:rgb(12,52,61);font-family:Arial;font-size:x-small"><br></span></p><p \
class="MsoNormal"><font face="Arial"><br></font></p></div></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]