Just had a feature request from Wheeler, and I don't see why it shouldn't
go on our todo list.
Currently, in psql you can do:
\set myvar 2008-10-23
and you can do
\set myvar `date`
but you can't do
\set myvar "Select now()"
even though you could, bizarrely, do:
\set myvar `psql -c "SELECT now();"`
... provided you were willing to parse out the garbage in the output.
This seems inconsistent, and it seems like the ability to store the results
of a single-row-returning query in a psql variable would be useful for
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2008-10-22 22:48:37|
|Subject: Re: psql Feature request \set query|
|Previous:||From: Josh Berkus||Date: 2008-10-22 22:31:48|
|Subject: Re: Reminder: only 10 days until final CommitFest|