wrong:
pa...@nemesis ~]$ psql postgres -v x=10 -c "select :x"
ERROR: syntax error at or near ":"
LINE 1: select :x
^
good (workaround):
[pa...@nemesis ~]$ echo 'select :x' | psql postgres -v x=10
?column?
──────────
10
(1 row)
psql have to have process external variables first and then execute query.
Regards
Pavel Stehule
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
