Thread: User input in psql

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

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