Re: Having trouble passing a shell variable to a query from psql command line

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Having trouble passing a shell variable to a query from psql command line
Дата
Msg-id CAKFQuwaAeF52LOpxjUUH0F3PN3w2CX8J-HJ=rV5wrzp1iyL=cQ@mail.gmail.com
обсуждение исходный текст
Ответ на Having trouble passing a shell variable to a query from psql command line  (Murthy Nunna <mnunna@fnal.gov>)
Ответы Re: Having trouble passing a shell variable to a query from psql command line
Список pgsql-admin
Дерево обсуждения
On Fri, Aug 29, 2025 at 10:52 AM Murthy Nunna <mnunna@fnal.gov> 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.

В списке pgsql-admin по дате отправления: