Thread: New to PostgreSQL - looking for query writing tools

New to PostgreSQL - looking for query writing tools

From
Troy Sherven
Date:

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

Re: New to PostgreSQL - looking for query writing tools

From
Robin Tang
Date:
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@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

Re: New to PostgreSQL - looking for query writing tools

From
Giovanni Biscontini
Date:
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@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 <tsherven@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:
biscontini.g@es2000.it

 Skype: g.biscontini.eurosystem2000

 WEB: https://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