Обсуждение: PSQL Tools

Hello

Is anyone aware of any tools like TOAD that are available for Postgresql?

Regards

John Wiencek

On 10/18/2015 07:04 AM, jwiencek3@comcast.net wrote:
> Hello
>
> Is anyone aware of any tools like TOAD that are available for Postgresql?

The universe of database management tools is large. In order to answer
the above, what is is that you want to do?

>
> Regards
>
> John Wiencek


--
Adrian Klaver
adrian.klaver@aklaver.com

On 10/18/2015 07:48 AM, jwiencek3@comcast.net wrote:
>
> Hello
>
> I am looking for a tool like TOAD for DBA's.   I would like something
> that can generate/extract DDL; report manage tablespace, create explain
> plans, create/mange users, synonyms, triggers, etc.

Well psql can do that:):

http://www.postgresql.org/docs/9.4/interactive/app-psql.html

Though I am guessing you are looking for a GUI interface, so:

http://www.pgadmin.org/

Synonyms do not exist in the community Postgres.

>
>
> regards
>
> John Wiencek
> ------------------------------------------------------------------------
> *From: *"Adrian Klaver" <adrian.klaver@aklaver.com>
> *To: *jwiencek3@comcast.net, pgsql-general@postgresql.org
> *Sent: *Sunday, October 18, 2015 9:32:45 AM
> *Subject: *Re: [GENERAL] PSQL Tools
>
> On 10/18/2015 07:04 AM, jwiencek3@comcast.net wrote:
>  > Hello
>  >
>  > Is anyone aware of any tools like TOAD that are available for Postgresql?
>
> The universe of database management tools is large. In order to answer
> the above, what is is that you want to do?
>
>  >
>  > Regards
>  >
>  > John Wiencek
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 2015-10-18 08:04, jwiencek3@comcast.net wrote:
> Hello
>
> Is anyone aware of any tools like TOAD that are available for Postgresql?

DBeaver works will all kinds of databases, DB2, Sybase, Oracle, SQLite, MySQL
and PostgreSQL. It's written in Java and runs anywhere a JVM will:

http://dbeaver.jkiss.org/


PostgreSQL only:

http://www.pgadmin.org/


--
http://yves.zioup.com
gpg: 4096R/32B0F416

jwiencek3@comcast.net schrieb am 18.10.2015 um 16:04:
> Is anyone aware of any tools like TOAD that are available for Postgresql?

https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

On Sun, 2015-10-18 at 14:48 +0000, jwiencek3@comcast.net wrote:
>
> Hello
>
> I am looking for a tool like TOAD for DBA's.   I would like something
> that can generate/extract DDL; report manage tablespace, create
> explain plans, create/mange users, synonyms, triggers, etc.
>
>
> regards
>
> John Wiencek


If you have a JDK 1.7 or above installed, you can use Execute Query (ww
w.executequery.org). You need to install the jdbc driver appropriate to
your Postgres version.

If you define your FK constraints in your schema, it can generate an ER
diagram. It can also do everything else you might want to manipulate a
data base. Another handy feature is import/export from/to either a
delimited file or XML format.

HTH,

Rob

On 2015-10-18 16:37, Nicolas Paris wrote:
>
> ​I didn't know DBeaver, it looks great ! (I personnally have many bugs/freeze
> with pgadmin3 on ubuntu, moreover the interface is not userfriendly)​

It also has the advantage of working with all the major database engines, so
you can use the same tool across all of them.


--
http://yves.zioup.com
gpg: 4096R/32B0F416