From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Cc: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: using placeholders in psql |
Date: | 2001-05-05 21:28:20 |
Message-ID: | Pine.LNX.4.30.0105052323200.769-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Oleg Bartunov writes:
> just an idea to use placeholders (?) in psql.
> It would be useful for interactive work and debuging.
> We already have powerful features in psql but sometimes
> we need more. If user enter select string with placeholder,
> he may get prompt to input something for arg1, then for arg2...
You can simulate this:
$ cat test.sql
\echo -n 'Enter something: '
\set val1 `read && echo $REPLY`
\echo -n 'And something else: '
\set val2 `read && echo $REPLY`
select :val1, :val2;
$ psql -f test.sql
Enter something: 55<enter>
And something else: 77<enter>
?column? | ?column?
----------+----------
55 | 77
(1 row)
Does this work for your application?
The question marks pose too much of an incompatibility problem. The :var
notation was already much disputed, even though it's kind of standard.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2001-05-06 09:34:59 | Re: using placeholders in psql |
Previous Message | Oleg Bartunov | 2001-05-05 18:44:09 | using placeholders in psql |