Re: PSQL Tools

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