SQL script prompting for value
J.R. Onyschak <jonyschak@nvisia.com>
From: "J.R. Onyschak" <jonyschak@nvisia.com>
To: pgsql-general@postgresql.org
Date: 2001-05-29T17:17:31Z
Lists: pgsql-general
I would like to have a sql script prompt the user for a value to use for
the rest of the script. In oracle I would do:
accept city_key prompt 'Enter city key (ex: IL-CITY):'
INSERT INTO city_info (muni_id, contact_first_name, contact_last_name)
VALUES ('&city_key','','');
Is anything like this possible using psql?
Thanks,
J.R.