Re: A PGsendQuery API design for your review

From: Joe Abbate <jma(at)freedomcircle(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Re: A PGsendQuery API design for your review
Date: 2016-02-03 20:27:25
Message-ID: 56B262AD.2020107@freedomcircle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On 02/02/16 16:30, Karl O. Pinc wrote:
> Thanks, but I don't think so. Those are interactive
> python shells. What they want is a web-enabled psql;
> a SQL shell.
>
> Many years ago I did a horrible hack of phpPgAdmin
> to give them such a shell (it parses sql). I'd
> like to move forward.

I haven't played much with your particular problem, but it seems that
adminer does what you want. You can SELECT from a table from the left
panel, then restrict the data that you want using dropdowns, and you'll
see the generated SQL before the results with an Edit link. If you
click on that and then add a semicolon and another query, it returns two
sets of results.

Joe

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Karl O. Pinc 2016-02-05 07:44:55 Re: A PGsendQuery API design for your review
Previous Message Federico Di Gregorio 2016-02-03 08:15:52 Re: A PGsendQuery API design for your review