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`
in psql. I think we will have \prompt in 8.3.
--
Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(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
