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@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
