Re: Feature Request: SQL parameters

From: Vik Reykja <vikreykja(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Eric Schwarzenbach <subscriber(at)blackbrook(dot)org>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Feature Request: SQL parameters
Date: 2011-03-05 21:21:05
Message-ID: AANLkTi=WatodKDr5khf1oM5VergUKTRrjWS14sHn8UKL@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Sat, Mar 5, 2011 at 20:39, Guillaume Lelarge <guillaume(at)lelarge(dot)info>wrote:

> I'm not sure I understand what you would like to have. That pgAdmin asks
> for values anytime it encounters a question mark in a query?
>

Yes, and I would really like that, too. As well as named parameters and
things like $1.
Look how fun psql is to use:

vik=# \set paramname 5
vik=# select :paramname;
?column?
----------
5
(1 row)

vik=#

It would be great if pgAdmin could excute similar queries.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Christopher Head 2011-03-06 11:15:16 Re: Feature request: ability to set hostaddr
Previous Message Guillaume Lelarge 2011-03-05 19:39:53 Re: Feature Request: SQL parameters