Run Time Variables

From: Phil Hayward <phil(at)springfield(dot)uklinux(dot)net>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Run Time Variables
Date: 2001-03-10 18:37:39
Message-ID: 01031018501900.00710@linux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)springfield(dot)co(dot)nz
phil(at)springfield(dot)uklinux(dot)net

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message mikhail malamud 2001-03-11 03:55:11 add primary key
Previous Message Arcady Genkin 2001-03-10 12:27:28 Not incrementing the 'serial' counter on failed inserts.