我使用bash脚本中的代码替换postgres数据库中标题列中带有空格的单引号。my_database -c "UPDATE my_table SET title = regexp_replace(title, '''', ' ', 'g')"this is example 'number one' okthis is example number one
撇号'将变成:右单引号’ (U+2019)或左单引号‘ 我们可以保证输入在语法上是正确的英语句子。变成I’m doing great!"Aren't you a little short?"变成“Aren’t you a little short?”"变成“When you said ‘Commas don’t matter,’ I die