psql variable interpolation from command line

psql variable interpolation from command line

am 01.10.2004 15:24:11 von Jeff Boes

I'm at a loss to explain this one:

$ psql -v AUTHOR="'foo'" -c 'select :AUTHOR;'
ERROR: syntax error at or near ":" at character 8

$ psql -v AUTHOR="'foo'"
....
# select :AUTHOR;
?column?
----------
foo
(1 row)


In other words, why won't variable interpolation work when the "-c" flag is
used?

--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Re: psql variable interpolation from command line

am 01.10.2004 15:28:59 von Jeff Boes

Ugh, never mind. I finally saw the reason in the 'psql' documentation. Missed it
the first time. (And the second, and third, ...)

--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise