Thread: New to PostgreSQL - looking for query writing tools

New to PostgreSQL - looking for query writing tools

From

Troy Sherven

Date:

01 February 2023, 19:43:42

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:

01 February 2023, 20:00:34

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:

02 February 2023, 10:34:12

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