Ron Johnson <ronljohnsonjr(at)gmail(dot)com> writes:
> Yeah. From the cli KISS and do regular bash variable string expansion.
> psql -d mydb -tAc "SELECT relkind FROM pg_class WHERE relname =
> ${SHELL_VAR} ;"
This isn't a great recommendation because bash is not aware of
SQL's quoting rules. It'll work in simple cases, but there's
a risk of SQL injection if the value of SHELL_VAR comes from
an untrustworthy source.
regards, tom lane