如何在 psql 的命令行查询中转义单引号? [英] How do I escape single quote in command line query of psql?

问题描述

我用谷歌搜索了很多，但是..

I googled a lot but..

如何在 psql 的命令行查询中转义单引号?

How do I escape single quote in command line query of psql ?

psql -t -A -F $'\t' postgresql://zzzz:5432/casedb -U qqqq -c 'select id,ext_ids ->> 'qwe' as qwe from data ORDER BY qwe' > /jdata/qwe.tab

结果出错

ERROR:  column "qwe" does not exist
LINE 1: select id,ext_ids ->> qwe as qwe from data...

推荐答案

在 Postgres 中你可以使用 美元引用的字符串:

In Postgres you can use dollar-quoted strings:

select id,ext_ids ->> $$qwe$$ as qwe from data ORDER BY qwe;
-- or
select id,ext_ids ->> $anything$qwe$anything$ as qwe from data ORDER BY qwe;

这篇关于如何在 psql 的命令行查询中转义单引号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！