pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedRe-2: New to PostgreSQL - looking for query writing tools
4+ messages / 4 participants
[nested] [flat]
* Re-2: New to PostgreSQL - looking for query writing tools
@ 2023-02-02 07:51 Sacha Kerres <skerres@kerres-edv.de>
0 siblings, 0 replies; 4+ messages in thread
From: Sacha Kerres @ 2023-02-02 07:51 UTC (permalink / raw)
To: Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi,
we use sqlmanager.net tools: Query, DBCompare, Data Compare, Automatic Tasks, Backup+Restore, etc...
There is a free version, but for professional work, you have to buy a license. But there is only a windows version.
Mit freundlichen Grüßen
Sacha Kerres
Kerres-EDV Beratung
Deglhof 45-47
93142 Maxhütte-Haidhof
Tel. +49 9471 60 14 14
Mobil. +49 171 210 48 46
E-Mail. skerres@kerres-edv.de
Original Message processed by david®
Re: New to PostgreSQL - looking for query writing tools 2. Februar 2023, 08:34 Uhr
Von Giovanni Biscontini
An pgsql-general@lists.postgresql.org
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
To: biscontini.g@es2000.it
pgsql-general@lists.postgresql.org
Attachments:
smime.p7s (application/x-pkcs7-signature, 4.5K) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re-2: New to PostgreSQL - looking for query writing tools
@ 2023-02-02 08:08 Brent Wood <Brent.Wood@niwa.co.nz>
2023-02-02 08:50 ` Re: Re-2: New to PostgreSQL - looking for query writing tools Jiten Kumar Shah <jitenshah78@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Brent Wood @ 2023-02-02 08:08 UTC (permalink / raw)
To: Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
The free version of Valentina Studio and DBeaver are the two I prefer....
If you use Postgis for spatial data, DBeaver understands geometry data & can display data on a simple map or as tabular output, with a built in Leaflet facility.
https://valentina-db.com/en/studio/download
https://dbeaver.io/
Brent Wood
________________________________
From: Sacha Kerres
Sent: Thursday, February 02, 2023 20:51
To: Giovanni Biscontini; pgsql-general@lists.postgresql.org
Subject: Re-2: New to PostgreSQL - looking for query writing tools
Hi,
we use sqlmanager.net tools: Query, DBCompare, Data Compare, Automatic Tasks, Backup+Restore, etc...
There is a free version, but for professional work, you have to buy a license. But there is only a windows version.
Mit freundlichen Grüßen
Sacha Kerres
Kerres-EDV Beratung
Deglhof 45-47
93142 Maxhütte-Haidhof
Tel. +49 9471 60 14 14
Mobil. +49 171 210 48 46
E-Mail. skerres@kerres-edv.de
Original Message processed by david®<https://david.tobit.software;
Re: New to PostgreSQL - looking for query writing tools 2. Februar 2023, 08:34 Uhr
Von Giovanni Biscontini<mailto:biscontini.g@es2000.it>
An pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org>
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<mailto: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<mailto: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
[https://ci3.googleusercontent.com/mail-sig/AIorK4wW12ZNDdF_BcmKN6zTAWE_BVey5jo0Vjx6DCd3Lh8QNf7OZ5pyI...]
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<mailto: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
To: biscontini.g@es2000.it
pgsql-general@lists.postgresql.org
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] <https://www.niwa.co.nz;
Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529
National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz<https://www.niwa.co.nz; Facebook<https://www.facebook.com/nzniwa; LinkedIn<https://www.linkedin.com/company/niwa; Twitter<https://twitter.com/niwa_nz; Instagram<https://www.instagram.com/niwa_science;
To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re-2: New to PostgreSQL - looking for query writing tools
2023-02-02 08:08 Re: Re-2: New to PostgreSQL - looking for query writing tools Brent Wood <Brent.Wood@niwa.co.nz>
@ 2023-02-02 08:50 ` Jiten Kumar Shah <jitenshah78@gmail.com>
2023-02-02 11:27 ` Re: Re-2: New to PostgreSQL - looking for query writing tools AR <ar@rabatin.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jiten Kumar Shah @ 2023-02-02 08:50 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
You can try https://github.com/OmniDB/OmniDB is not active but it is
working and also available in postgres debian repo
On 2/2/23 13:38, Brent Wood wrote:
> The free version of Valentina Studio and DBeaver are the two I prefer....
>
> If you use Postgis for spatial data, DBeaver understands geometry data
> & can display data on a simple map or as tabular output, with a built
> in Leaflet facility.
>
> https://valentina-db.com/en/studio/download
> https://dbeaver.io/
>
>
> Brent Wood
>
> ------------------------------------------------------------------------
> *From:* Sacha Kerres
> *Sent:* Thursday, February 02, 2023 20:51
> *To:* Giovanni Biscontini; pgsql-general@lists.postgresql.org
> *Subject:* Re-2: New to PostgreSQL - looking for query writing tools
>
> Hi,
> we use sqlmanager.net tools: Query, DBCompare, Data Compare,
> Automatic Tasks, Backup+Restore, etc...
>
> There is a free version, but for professional work, you have to buy a
> license. But there is only a windows version.
>
> Mit freundlichen Grüßen
> Sacha Kerres
> Kerres-EDV Beratung
> Deglhof 45-47
> 93142 Maxhütte-Haidhof
> Tel. +49 9471 60 14 14
> Mobil. +49 171 210 48 46
> E-Mail. skerres@kerres-edv.de
>
> Original Message processed by david® <https://david.tobit.software;
>
> *Re: New to PostgreSQL - looking for query writing tools* 2.
> Februar 2023, 08:34 Uhr
> *Von* Giovanni Biscontini <mailto:biscontini.g@es2000.it>
> *An* pgsql-general@lists.postgresql.org
>
> 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 <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*
>
>
>
> To: biscontini.g@es2000.it
> pgsql-general@lists.postgresql.org
> <https://www.niwa.co.nz; Brent Wood
> Principal Technician - GIS and Spatial Data Management
> Programme Leader - Environmental Information Delivery
> +64-4-386-0529
>
> National Institute of Water & Atmospheric Research Ltd (NIWA)
> 301 Evans Bay Parade Hataitai Wellington New Zealand
> *Connect with NIWA:* niwa.co.nz <https://www.niwa.co.nz; Facebook
> <https://www.facebook.com/nzniwa; LinkedIn
> <https://www.linkedin.com/company/niwa; Twitter
> <https://twitter.com/niwa_nz; Instagram
> <https://www.instagram.com/niwa_science;
>
> To ensure compliance with legal requirements and to maintain cyber
> security standards, NIWA's IT systems are subject to ongoing
> monitoring, activity logging and auditing. This monitoring and
> auditing service may be provided by third parties. Such third parties
> can access information transmitted to, processed by and stored on
> NIWA's IT systems
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re-2: New to PostgreSQL - looking for query writing tools
2023-02-02 08:08 Re: Re-2: New to PostgreSQL - looking for query writing tools Brent Wood <Brent.Wood@niwa.co.nz>
2023-02-02 08:50 ` Re: Re-2: New to PostgreSQL - looking for query writing tools Jiten Kumar Shah <jitenshah78@gmail.com>
@ 2023-02-02 11:27 ` AR <ar@rabatin.com>
0 siblings, 0 replies; 4+ messages in thread
From: AR @ 2023-02-02 11:27 UTC (permalink / raw)
To: jitenshah78@gmail.com; pgsql-general@lists.postgresql.org
I use Jetbrains datagrip. I am using pycharm for python dev and datagrip has a similar UI.
Sent from Proton Mail mobile
-------- Original Message --------
On Feb 2, 2023, 3:50 AM, Jiten Kumar Shah wrote:
> You can try https://github.com/OmniDB/OmniDB is not active but it is working and also available in postgres debian repo
>
> On 2/2/23 13:38, Brent Wood wrote:
>
>> The free version of Valentina Studio and DBeaver are the two I prefer....
>>
>> If you use Postgis for spatial data, DBeaver understands geometry data & can display data on a simple map or as tabular output, with a built in Leaflet facility.
>>
>> https://valentina-db.com/en/studio/download
>>
>> https://dbeaver.io/
>>
>> Brent Wood
>>
>> ---------------------------------------------------------------
>> From: Sacha Kerres
>> Sent: Thursday, February 02, 2023 20:51
>> To: Giovanni Biscontini; pgsql-general@lists.postgresql.org
>> Subject: Re-2: New to PostgreSQL - looking for query writing tools
>>
>> Hi,
>> we use sqlmanager.net tools: Query, DBCompare, Data Compare, Automatic Tasks, Backup+Restore, etc...
>>
>> There is a free version, but for professional work, you have to buy a license. But there is only a windows version.
>>
>> Mit freundlichen Grüßen
>>
>> Sacha Kerres
>> Kerres-EDV Beratung
>> Deglhof 45-47
>> 93142 Maxhütte-Haidhof
>>
>> Tel. +49 9471 60 14 14
>> Mobil. +49 171 210 48 46
>> E-Mail. skerres@kerres-edv.de
>>
>>> [Original Message processed by david®](https://david.tobit.software)
>>> Re: New to PostgreSQL - looking for query writing tools 2. Februar 2023, 08:34 Uhr
>>> Von [Giovanni Biscontini](mailto:biscontini.g@es2000.it)
>>> An pgsql-general@lists.postgresql.org
>>> 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](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
>>
>> To: biscontini.g@es2000.it
>> pgsql-general@lists.postgresql.org
>> https://www.niwa.co.nz Brent Wood
>> Principal Technician - GIS and Spatial Data Management
>> Programme Leader - Environmental Information Delivery
>> +64-4-386-0529
>>
>> National Institute of Water & Atmospheric Research Ltd (NIWA)
>> 301 Evans Bay Parade Hataitai Wellington New Zealand
>> Connect with NIWA: [niwa.co.nz](https://www.niwa.co.nz) [Facebook](https://www.facebook.com/nzniwa) [LinkedIn](https://www.linkedin.com/company/niwa) [Twitter](https://twitter.com/niwa_nz) [Instagram](https://www.instagram.com/niwa_science) To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-02-02 11:27 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-02 07:51 Re-2: New to PostgreSQL - looking for query writing tools Sacha Kerres <skerres@kerres-edv.de>
2023-02-02 08:08 Re: Re-2: New to PostgreSQL - looking for query writing tools Brent Wood <Brent.Wood@niwa.co.nz>
2023-02-02 08:50 ` Jiten Kumar Shah <jitenshah78@gmail.com>
2023-02-02 11:27 ` AR <ar@rabatin.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox