今天有开发人员咨询如何插入包含单引号的字符串，例如 kate’s horse，网上查了下资料，最后还是文档中给出了解释，如下:

单引号的转义

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 (“).

备注：文档中说的很清楚，写两个单引号即可，注意不能写成双引号。

测试

1
2
3
4
5
6
7
8
9
10

francs=> create table test_3(id int4,name text);  
CREATE TABLE  
  
francs=> insert into test_3 (id,name) values (1,'kate''s horse');  
INSERT 0  1  
  
francs=>  select  *  from test_3;  
id | name   
----+--------------  
 1  | kate's horse

参考

• http://www.postgresql.org/docs/9.3/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS