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 <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
