Re: A PGsendQuery API design for your review - Mailing list psycopg

From Joe Abbate
Subject Re: A PGsendQuery API design for your review
Date
Msg-id 56B262AD.2020107@freedomcircle.com
Whole thread Raw
In response to Re: A PGsendQuery API design for your review  ("Karl O. Pinc" <kop@meme.com>)
Responses Re: A PGsendQuery API design for your review
Re: A PGsendQuery API design for your review
List 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



psycopg by date:

Previous
From: Federico Di Gregorio
Date:
Subject: Re: A PGsendQuery API design for your review
Next
From: "Karl O. Pinc"
Date:
Subject: Re: A PGsendQuery API design for your review