DomainKey-Signature: a=rsa-sha1; c=nofws; d=pobox.com; h=date:from:to
	:subject:message-id:references:mime-version:content-type
	:in-reply-to:content-transfer-encoding; q=dns; s=sasl; b=v828HGH
	L+KGzavoVdceqyycBBbdSczWF9EGN6dxEi5vY3iVc0qX1VNHmU6yAhbbA2d4kjeo
	aG3q61wtNfhZzYiC9Dbfhq4Hg3ezd00/6JyJY8w8IE4Ls2ptQmsrB1yviRVWPkAn
	PdcE6yFdQjGXFXg5g2AsZN4Slv7ZMtCuGhXA=
Date: Sat, 21 Sep 2019 09:25:22 -0400
From: "Anthony E. Greene" <agreene@pobox.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
Message-ID: <20190921132522.GA26861@lnxws01.localdomain>
References: 
 <CAMPA5gcyOR9J1zSmL__0_PiDZvDHNZkSzifjRRZO7ocsAga23A@mail.gmail.com>
 <F22D82C9-8495-4F41-BB49-A86B66B43601@1nar.com.tr>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <F22D82C9-8495-4F41-BB49-A86B66B43601@1nar.com.tr>
OpenPGP: id=7B3DBD7D7D911B44BA26C484A42A60DD6C94239D;
  url=http://www.greene-family.org/tony/pgp/0x6C94239D.asc;
  preference=signencrypt
User-Agent: Mutt/1.12.1 (2019-06-15)
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

On 20-Sep-2019/19:09 +0300, Ertan K=C3=BC=C3=A7=C3=BCko=C4=9Flu <ertan.ku=
cukoglu@1nar.com.tr> wrote:
>
>My main usage is to see select results.

I have used zenity and a shell script for this.

The script uses zenity to present a list of databases. The script assumes
you do not need credentials to connect to the database. You could specify
a connection string if username/password credentials are needed.

After selecting a database, a zenity text input dialog is displayed so
that you can enter a command. The script uses psql to run the command,
with the --html option to output to an HTML file. It then uses xdg-open t=
o
launch your default HTML viewer with the file.

My browser opens a new tab every time, but I can live with that.

The script redisplays the zenity text input box after each command, until
you select the Cancel button, use the Escape key, or close the zenity
window.

It does not check syntax, and it does not report errors. It only provides
a quick way to run queries and get the results in a browser.

Let me know if you're interested.

--=20
Anthony E. Greene <mailto:agreene@pobox.com>