PSQL Tools

Op 18-10-2015 om 16:04 schreef jwiencek3@comcast.net:

Hello

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

Regards

John Wiencek

There are several, I use EMS SQL-manager freeware version. The commecial
version has more features, but the freeware version supports enough to
get all your basic work done; browse data, modify DDL, including
functions and triggers. It is a windows program but runs well on wine.

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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
----- Original Message -----

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

PgAdmin seems to fit those requirements. It's free.and available for
multiple platforms.

http://www.pgadmin.org/

What O/S do you wish to install on?

On Sun, Oct 18, 2015 at 10: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.

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

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

windows or Mac OS

----- Original Message -----

From: "Melvin Davidson" <melvin6925@gmail.com>
To: jwiencek3@comcast.net
Cc: "Adrian Klaver" <adrian.klaver@aklaver.com>, pgsql-general@postgresql.org
Sent: Sunday, October 18, 2015 9:55:26 AM
Subject: Re: [GENERAL] PSQL Tools

PgAdmin seems to fit those requirements. It's free.and available for multiple platforms.

http://www.pgadmin.org/

What O/S do you wish to install on?

On Sun, Oct 18, 2015 at 10: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.

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

--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

On Sun, Oct 18, 2015 at 7:04 AM, <jwiencek3@comcast.net> wrote:

Hello

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

PgAdmin fits here.

Regards

John Wiencek

--

Regards,
Dinesh
manojadinesh.blogspot.com

2015-10-19 0:08 GMT+02:00 dinesh kumar <dineshkumar02@gmail.com>:

On Sun, Oct 18, 2015 at 7:04 AM, <jwiencek3@comcast.net> wrote:

Hello

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

PgAdmin fits here.

Regards

John Wiencek

--

Regards,
Dinesh
manojadinesh.blogspot.com

​I didn't know DBeaver, it looks great ! (I personnally have many
bugs/freeze with pgadmin3 on ubuntu, moreover the interface is not
userfriendly)​

PgAdmin works great on Windows and is also available for the Mac.

You can find both versions here:

http://www.pgadmin.org/download/windows.php
or
http://www.pgadmin.org/download/macosx.php

On Sun, Oct 18, 2015 at 6:37 PM, Nicolas Paris <niparisco@gmail.com> wrote:

2015-10-19 0:08 GMT+02:00 dinesh kumar <dineshkumar02@gmail.com>:

On Sun, Oct 18, 2015 at 7:04 AM, <jwiencek3@comcast.net> wrote:

Hello

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

PgAdmin fits here.

Regards

John Wiencek

--

Regards,
Dinesh
manojadinesh.blogspot.com

​I didn't know DBeaver, it looks great ! (I personnally have many
bugs/freeze with pgadmin3 on ubuntu, moreover the interface is not
userfriendly)​

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Yes, moreover it provides SQL auto-completion (ctrl+space), query history,
The eclipse workbench is easy, fast & reactiv.
Hope I had kown DBeaver before

2015-10-19 14:49 GMT+02:00 Yves Dorfsman <yves@zioup.com>: