David Fetter wrote:
> On Fri, Feb 16, 2007 at 08:23:48PM -0500, Bruce Momjian wrote:
>> Ashish Karalkar wrote:
>>> Hello All,
>>> I want to prompt user to input some value and do some action on that value in runtime of a sql script.
>>> Is there any psql command to do this ??
>>> I can use \echo do display massage
>>> but to take input what is the command?
>>> Thanks in advance
>> You can do:
>>
>> \echo -n 'Enter value: '
>> \set x `read && echo $REPLY`
>
> Neat trick! Is there one that works on all our supported platforms?
> I'm guessing Win32 will just get confused about backticks.
Win32 will deal with the backticks Ok, but not the read && echo part.
You can set it to the output of a variable, for example
\set x `echo foo`
but I haven't been able to trick it into actually reading something. One
would think something like:
\set x `set /p Z= && echo %Z%`
would work, but it doesn't. One reason for this is that %Z% is actually
resolved at parsing time. it's a pain in CMD language, but that's how it
works. :-(
//Magnus