Re: New to PostgreSQL - looking for query writing tools

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*