Horton

Run Time Variables

Phil Hayward <phil@springfield.uklinux.net>

View thread View on postgr.es
From: Phil Hayward <phil@springfield.uklinux.net>
To: "'pgsql-novice@postgresql.org'" <pgsql-novice@postgresql.org>
Date: 2001-03-10T18:37:39Z
Lists: pgsql-novice 
Can anyone assist please?
In Oracle it is possible to enter variables at run time with a query as follows

SELECT name, salary, dept
FROM emp
WHERE empid = &empid;

On running the query you will be prompted .....

Enter value for empid:

Is there an equivalent feature in PostgreSql, Psql ?


-- 
Phil Hayward
London, England

phil@springfield.co.nz
phil@springfield.uklinux.net