Re: using placeholders in psql - Mailing list pgsql-interfaces

From Peter Eisentraut
Subject Re: using placeholders in psql
Date
Msg-id Pine.LNX.4.30.0105052323200.769-100000@peter.localdomain
Whole thread Raw
In response to using placeholders in psql  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: using placeholders in psql
List 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@gmx.net   http://funkturm.homeip.net/~peter



pgsql-interfaces by date:

Previous
From: Oleg Bartunov
Date:
Subject: using placeholders in psql
Next
From: Oleg Bartunov
Date:
Subject: Re: using placeholders in psql