From: | Eric Schwarzenbach <subscriber(at)blackbrook(dot)org> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Feature Request: SQL parameters |
Date: | 2011-03-02 23:03:01 |
Message-ID: | 4D6ECCA5.703@blackbrook.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Some years ago I worked with another DB tool, for another DB that
offered support for SQL parameters in a way that was extremely handy.
I've missed this feature in pgAdmin ever since. By SQL parameters, I
mean the replaceable bits one puts as ? in a prepared statement.
When testing / debugging sql from application code, it is a major
annoyance to have to constantly find and replace these ?'s. I forget
exactly how the feature in the other tool worked...it may have actually
detected the ?'s and prompted you for values the moment you tried to
execute it. But the important thing was that it allowed you to leave the
?'s in the query, and gave you a place to fill in the parameter values
to be used when you execute it. This may not sound like much on the
surface, but makes an enormous difference. It:
* avoids having to hunt down the ? in a large complex query
* keeps your query looking more as it appears in your source code (and
you can more easily paste it back in after you've modified it in pgadmin)
* keeps you from losing track of where the ?s were before you replaced them
* is handier for testing out different values for the parameters.
From | Date | Subject | |
---|---|---|---|
Next Message | John Huss | 2011-03-02 23:03:59 | paste into SQL editor from Eclipse on Mac doesn't work |
Previous Message | Andreas Neumann | 2011-03-02 07:06:03 | Re: Feature request: ability to set hostaddr |