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. sker...@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 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 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: biscontin...@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: biscontin...@es2000.it
pgsql-general@lists.postgresql.org
smime.p7s
Description: S/MIME cryptographic signature