I use Jetbrains datagrip. I am using pycharm for python dev and datagrip has a similar UI.
Sent from Proton Mail mobile -------- Original Message -------- On Feb 2, 2023, 3:50 AM, Jiten Kumar Shah wrote: > 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@lists.postgresql.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. sker...@kerres-edv.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:biscontin...@es2000.it) >>> An pgsql-general@lists.postgresql.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 <ro...@artie.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 <tsher...@mcd.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: biscontin...@es2000.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: biscontin...@es2000.it >> pgsql-general@lists.postgresql.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