[servername]# su postgres -c 'cd ~; psql -c "SELECT * FROM pg_catalog.pg_user WHERE usename LIKE name;"'
ERROR: column "name" does not exist
LINE 1: SELECT * FROM pg_catalog.pg_user WHERE usename LIKE name;
^
嘗試了多種方式，但沒有一種方式回傳正確的回應。可能有更漂亮的命令列查詢方式嗎？
uj5u.com熱心網友回復：
/usr/local/pgsql15/bin/psql -c "SELECT * FROM pg_catalog.pg_user WHERE usename like 'admin'"
使它成為兩行。
/usr/local/pgsql15/bin/psql test15 -c \
"SELECT * FROM pg_catalog.pg_user WHERE usename like 'admin'"
或者
/usr/local/pgsql15/bin/psql test15 <<<"SELECT * FROM pg_catalog.pg_user WHERE usename like 'admin'"
或者
echo "SELECT * FROM pg_catalog.pg_user WHERE usename like 'admin'" | /usr/local/pgsql15/bin/psql test15
百分號仍然有效。
/usr/local/pgsql15/bin/psql test15 -c \
"SELECT * FROM pg_catalog.pg_user WHERE usename like '
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/537292.html