Re: user input during runtime

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.

> in psql. I think we will have \prompt in 8.3.

Well, I guess it's not all that crucial with \prompt coming out. :)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!