Re: [SQL] User input in psql

2005-11-02 Thread Richard Huxton
Ashok Agrawal wrote: Hi . Just wanted to know what is equivalent of "Oracle &" in postgresql. select count(*) from table1 where id =&1 where sqlplus plus will prompt to enter value for 1. I would like to do the same in psql. There isn't an equivalent feature, I'm afraid. There are variables y

[SQL] User input in psql

2005-11-02 Thread Ashok Agrawal
Hi . Just wanted to know what is equivalent of "Oracle &" in postgresql. select count(*) from table1 where id =&1 where sqlplus plus will prompt to enter value for 1. I would like to do the same in psql. Thanks Ashok ---(end of broadcast)--- TIP