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 you
can use, but no interactive prompting.
\set myvar foo
SELECT count(*) FROM table1 WHERE id = :foo;
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org