From: Jiten Kumar Shah <jitenshah78@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Re-2: New to PostgreSQL - looking for query writing tools
Date: Thu, 2 Feb 2023 14:20:23 +0530
Message-ID: <bf381b32-8760-1043-8af0-cb5f188f0747@GMAIL.COM> (raw)
In-Reply-To: <SY4PR01MB7076FC64091E68554E1BE679A1D69@SY4PR01MB7076.ausprd01.prod.outlook.com>
References: <SY4PR01MB7076FC64091E68554E1BE679A1D69@SY4PR01MB7076.ausprd01.prod.outlook.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: jitenshah78@gmail.com
Subject: Re: Re-2: New to PostgreSQL - looking for query writing tools
In-Reply-To: <bf381b32-8760-1043-8af0-cb5f188f0747@GMAIL.COM>
References: <SY4PR01MB7076FC64091E68554E1BE679A1D69@SY4PR01MB7076.ausprd01.prod.outlook.com> <bf381b32-8760-1043-8af0-cb5f188f0747@GMAIL.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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