From: Anthony E. Greene <agreene@pobox.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
Date: Sat, 21 Sep 2019 09:25:22 -0400
Message-ID: <20190921132522.GA26861@lnxws01.localdomain> (raw)
In-Reply-To: <F22D82C9-8495-4F41-BB49-A86B66B43601@1nar.com.tr>
References: <CAMPA5gcyOR9J1zSmL__0_PiDZvDHNZkSzifjRRZO7ocsAga23A@mail.gmail.com>
<F22D82C9-8495-4F41-BB49-A86B66B43601@1nar.com.tr>
On 20-Sep-2019/19:09 +0300, Ertan Küçükoğlu <ertan.kucukoglu@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 to
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.
--
Anthony E. Greene <mailto:agreene@pobox.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: agreene@pobox.com, pgsql-admin@lists.postgresql.org
Subject: Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
In-Reply-To: <20190921132522.GA26861@lnxws01.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox