如何包含有单引号的字符串

在PostgreSQL中，表示字符串时，用单引号将字符串包含起来。如 ‘foo’

如果字符串本身就包含单引号，就在有单引号的地方再加一个单引号。如要表示

O’Reilly

1

这个字符串。则表示成

‘O’’Reilly’

1

参考来源：

PostgreSQL 9.5官网文档

4.1. Lexical Structure

A string constant in SQL is an arbitrary sequence of characters bounded
by single quotes (‘), for example ‘This is a string’.

To include a single-quote character within a string constant, write two
adjacent single quotes, e.g., ‘Dianne”s horse’.

Note that this is not the same as a double-quote character (“).

---

版权声明：本文为CSDN博主「haohaibo031113」的原创文章，遵循CC 4.0
BY-SA版权协议，转载请附上原文出处链接及本声明。

原文链接：https://blog.csdn.net/haohaibo031113/article/details/53375001