pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 

view thread (4+ messages)  latest in thread

Message-ID: <bf381b32-8760-1043-8af0-cb5f188f0747@GMAIL.COM>
Permalink:  ../bf381b32-8760-1043-8af0-cb5f188f0747@GMAIL.COM/
Also on:    postgresql.org/message-id/bf381b32-8760-1043-8af0-cb5f188f0747@GMAIL.COM

 · 

reply

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