On Fri, Aug 29, 2025 at 10:52 AM Murthy Nunna <mnunna@xxxxxxxx> wrote:
psql -d mydb -t -A -c "SELECT relkind FROM pg_class WHERE relname = :'SHELL_VAR' ;" -v SHELL_VAR="$SHELL_VAR"
ERROR: syntax error at or near ":"
LINE 1: SELECT relkind FROM pg_class WHERE relname = :'SHELL_VAR' ;
^
Is psql script necessary to pass shell variable?
I appreciate any help you can provide.
I provide the documentation. Under psql -c:
"command must be either a command string that is completely parsable by the server (i.e., it contains no psql-specific features)"
Variable-substitution is a psql-specific feature.
David J.
