New to PostgreSQL - looking for query writing tools
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
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:
Show quoted text
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
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_ClientsI 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 <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*