我正在嘗試使用 Kubectl 運行查詢，如下所示：
kubectl -n employeesns exec -ti employeedpoddb-0 -- psql -d db_people -U postgres
-c 'create extension if not exists dblink;'
-c 'SELECT dbemployees."empId" , dbemployees."createdAt" , dbemployees."updatedAt"
from "users" as "dbemployees"
WHERE dbemployees."empId" not in (
SELECT "empId"
FROM dblink('dbname=peopledb','SELECT "empId" FROM employees')
AS dbpeople("empId" varchar)
)'
但是我得到
ERROR: syntax error at or near "SELECT"
LINE 1: ...SELECT "empId" FROM dblink(dbname=peopledb,SELECT
^
command terminated with exit code 1
我們如何使用 Kubectl 執行多行 SQL 查詢？
uj5u.com熱心網友回復：
那是因為你的內心'沒有逃脫；你會在本地看到同樣的東西
$ echo 'hello 'world' from shell'
您只需要根據您的需要轉義那些內部引號，或將外部引號更改為"然后轉義這些用法
-c 'SELECT dbemployees."empId" , dbemployees."createdAt" , dbemployees."updatedAt"
from "users" as "dbemployees"
WHERE dbemployees."empId" not in (
SELECT "empId"
FROM dblink('\''dbname=peopledb'\'','\''SELECT "empId" FROM employees'\'')
AS dbpeople("empId" varchar)
)'
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/470201.html
標籤：PostgreSQL Kubernetes 执行 psql kubectl