postgres dblink转义单引号

尝试替换

'inactive'

''inactive''

   SELECt *    FROM dblink('host=theHostName port=1234 dbname=theDBName user=theUser password=thePassword',        'SELECt field_1,         CASE WHEN field_2 IS NOT NULL         THEN ''inactive'' ELSE ''active''         END AS field_status         FROM the_table          ')AS linkresults(field_1 varchar(20),field_2 varchar(8))

替代（先前）解决方案

   SELECt *    FROM dblink('host=theHostName port=1234 dbname=theDBName user=theUser password=thePassword',        'SELECt field_1,         CASE WHEN field_2 IS NOT NULL         THEN E'inactive' ELSE E'active'         END AS field_status         FROM the_table          ')AS linkresults(field_1 varchar(20),field_2 varchar(8))