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*
