Re: Re-2: New to PostgreSQL - looking for query writing tools

You can try https://github.com/OmniDB/OmniDB is not active but it is
working and also available in postgres debian repo

On 2/2/23 13:38, Brent Wood wrote:
> The free version of Valentina Studio and DBeaver are the two I prefer....
>
> If you use Postgis for spatial data, DBeaver understands geometry data
> & can display data on a simple map or as tabular output, with a built
> in Leaflet facility.
>
> https://valentina-db.com/en/studio/download
> https://dbeaver.io/
>
>
> Brent Wood
>
> ------------------------------------------------------------------------
> *From:* Sacha Kerres
> *Sent:* Thursday, February 02, 2023 20:51
> *To:* Giovanni Biscontini; pgsql-general(at)lists(dot)postgresql(dot)org
> *Subject:* Re-2: New to PostgreSQL - looking for query writing tools
>
> Hi,
> we use sqlmanager.net tools:  Query, DBCompare, Data Compare,
> Automatic Tasks, Backup+Restore, etc...
>
> There is a free version, but for professional work, you have to buy a
> license. But there is only a windows version.
>
> Mit freundlichen Grüßen
> Sacha Kerres
> Kerres-EDV Beratung
> Deglhof 45-47
> 93142 Maxhütte-Haidhof
> Tel. +49 9471 60 14 14
> Mobil. +49 171 210 48 46
> E-Mail. skerres(at)kerres-edv(dot)de
>
> Original Message processed by david® <https://david.tobit.software>
>
> *Re: New to PostgreSQL - looking for query writing tools* 2.
> Februar 2023, 08:34 Uhr
> *Von* Giovanni Biscontini <mailto:biscontini(dot)g(at)es2000(dot)it>
> *An* pgsql-general(at)lists(dot)postgresql(dot)org
>
> Hi Troy,
>  we both use pgAdmin4 and DBeaver (https://dbeaver.io/) Community
> version but mainly 'cos we need to get in control of other
> functions of the database server, query is only a part of the job.
> Another interesting tool is Aquafold (https://www.aquafold.com)
> Aqua Data Studio is interesting (only tested) but it's a bit pricey...
> Hope it helps, bye Giovanni
>
> Il giorno mer 1 feb 2023 alle ore 18:00 Robin Tang
> <robin(at)artie(dot)so> ha scritto:
>
> There's a bunch listed here:
> https://wiki.postgresql.org/wiki/PostgreSQL_Clients
>
> I personally use Postico, but it's only available on Mac.
>
> On Wed, Feb 1, 2023 at 8:43 AM Troy Sherven <tsherven(at)mcd(dot)net>
> wrote:
>
> Good morning,
>
> First of all, I am not a database professional.  I work
> for a small company, and a portion of my job includes
> report writing (crystal, i-Net, etc), Excel analysis,
> etc.  We recently migrated to a new ERP that runs on a
> PostgreSQL database.  Our previous system was on a MSSQL
> database.  I have fairly basic experience writing SQL
> queries.  In the past I would use Microsoft SQL Server
> Management Studio to help in writing my SQL queries (I’d
> use the diagram, criteria, and SQL panes) instead of just
> writing SQL statements.
>
> I’m looking for recommendations of tools that would work
> similar to Microsoft SQL Server Management Studio.  So far
> I’ve played around with pgAdmin (doesn’t seem to have the
> same query writing abilities) and EMS SQL Query (seems
> more cumbersome than the Microsoft tool).  Are there any
> other tools I should be looking at for query writing help?
> I like to something visual and a grid to help write queries.
>
> Any recommendations would be appreciated!
>
> Troy
>
>
>
> --
>
> *Cordiali Saluti*
>
>
> ***Dott. Giovanni Biscontini*
>
> * [Divisone Software]*
>
> ***Str. Ponte Alto Sud, 74
>   41123 Modena  (MO)*
>
> Phone: 059_452094
>   Fax: 059_8672171
>   E-mail: biscontini(dot)g(at)es2000(dot)it
>
>  Skype: g.biscontini.eurosystem2000
>
> WEB: https://www.es2000.it <http://www.es2000.it/>
>
> ____________________________________
>
> Privacy e riservatezza: il presente messaggio, così come i
> relativi allegati, contengono dati ed informazioni da considerarsi
> strettamente riservate ed è indirizzato esclusivamente al
> destinatario sopra indicato, il quale è l'unico autorizzato a
> trattarlo in osservanza delle norme del Regolamento UE 2016/679
> (RGPD) . Preghiamo chiunque ricevesse questo messaggio per errore
> di evitare di copiarlo, divulgarlo, distribuirlo a terzi e di dare
> notizia al mittente dell’errato invio, distruggendone poi
> l'eventuale copia cartacea e la copia in formato elettronico.
>
> Il titolare dei dati potrà esercitare tutti i diritti di cui
> all'art.7 del suddetto decreto tra cui quelli di accesso,
> rettifica, aggiornamento, opposizione al trattamento e cancellazione
>
> *Please, print this e-mail only if necessary*
>
>
>
> To: biscontini(dot)g(at)es2000(dot)it
> pgsql-general(at)lists(dot)postgresql(dot)org
> <https://www.niwa.co.nz> Brent Wood
> Principal Technician - GIS and Spatial Data Management
> Programme Leader - Environmental Information Delivery
> +64-4-386-0529
>
> National Institute of Water & Atmospheric Research Ltd (NIWA)
> 301 Evans Bay Parade Hataitai Wellington New Zealand
> *Connect with NIWA:* niwa.co.nz <https://www.niwa.co.nz> Facebook
> <https://www.facebook.com/nzniwa> LinkedIn
> <https://www.linkedin.com/company/niwa> Twitter
> <https://twitter.com/niwa_nz> Instagram
> <https://www.instagram.com/niwa_science>
>
> To ensure compliance with legal requirements and to maintain cyber
> security standards, NIWA's IT systems are subject to ongoing
> monitoring, activity logging and auditing. This monitoring and
> auditing service may be provided by third parties. Such third parties
> can access information transmitted to, processed by and stored on
> NIWA's IT systems