Re: Developer GUI tools for PostgreSQL

From: JingYuan Chen <phil(dot)cyc(at)gmail(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Tim Uckun <timuckun(at)gmail(dot)com>, Brent Wood <pcreso(at)yahoo(dot)com>, Tiffany Thang <tiffanythang(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Developer GUI tools for PostgreSQL
Date: 2017-07-27 02:57:31
Message-ID: CA+7LKP=YT86NQPGq+zinXjXK4f6dvZxMiu_bjAAnJ7kVU_Ca-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I recommend that you can try Squirrel SQL.
(http://squirrel-sql.sourceforge.net/index.php?page=screenshots)

It is a SQL tool based on JVM. You can execute it whether on Linux or
WIndow, even MAC.
It use JDBC to connect Database. So that you can install differet JDBC
Driver to connect to different databases, such as Oracle (Thin Driver) ,
PostgreSQL (Pg JDBC), MS-SQL ( JTDS ) and so on.

Beside DDL oprations, I also use it to copy data in order to build sandbox
environment. Select the table, Right click and Copy it, then Paste it. Only
three steps to create a new table with data for test or development
purpose. Some nice facilities I often used are rotated table, view metadata
and monitor server performance. Yes, it can also export the data you
fetched as Excel or CVS file.

Try it and you will love it !

Regards,
Chingyuan

On Thu, Jul 27, 2017 at 9:31 AM, Joshua D. Drake <jd(at)commandprompt(dot)com>
wrote:

> On 07/26/2017 05:58 PM, Tim Uckun wrote:
>
>> I am waiting till pgadmin4 gets a bit faster. It seems kind of slow on my
>> mac.
>>
>
> PostgreSQL Studio
> Navicat
> EMS PostgreSQL Manager
> PgAdmin3 LTS (BigSQL)
>
> JD
>
>
> --
> Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
>
> PostgreSQL Centered full stack support, consulting and development.
> Advocate: @amplifypostgres || Learn: https://pgconf.us
> ***** Unless otherwise stated, opinions are my own. *****
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James Sewell 2017-07-27 03:00:17 Interesting streaming replication issue
Previous Message rob stone 2017-07-27 02:46:21 Re: Developer GUI tools for PostgreSQL