Thread: Pgadmin plugins
Hello,
I find pgadmin a nice software, but I think it lacks some fundamental functionalities mainly repositories support including git and cvs. Also, some enhancement on the editor would be nice such as auto completion, code ordering, coloring, etc. I have seen that pgadmin have a menu called plugins, what is it for ? Also, can some one recommend an open source tool like pgadmin that support repositories. The community link http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools contains many tools but there is no cross comparison which makes it difficult to pick up one. Also, if some one can recommend a plugin for netbeans, eclipse for same purpose above I will be greatfull.
Thanks in advance
On Thu, 2011-08-18 at 08:22 -0700, salah jubeh wrote: > Hello, > > I find pgadmin a nice software, but I think it lacks some fundamental > functionalities mainly repositories support including git and cvs. I also do think pgAdmin lacks some nice features, but repository support, I don't even understand what you want :) > Also, some enhancement on the editor would be nice such as auto completion Already in it. > , code ordering, Which means? > coloring Already has it. > , etc. I have seen that pgadmin have a menu called plugins, what is it for ? To launch tools. The most obvious ones are psql or pg_dump, but every tool you could imagine. IIRC, the PostGIS guys did a nice plugin (a shapefile loader, I guess). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Hello,
I need repository plug in in order to control my DDL, currently I am using text files to create sachems, procedures , etc. and it will be great if I can keep track of how the schema changes and even to protect against errors such as accidental file deletion.
Regarding code ordering , I mean indentation and order the sql code to make it more readable. this can found in all Integrated development environments for c++, and java.
regarding the plug in you are right I am using an old version so the psql console is not there, but is there away to enable repository plug in and get the text file in the Pgadmin editor.
Kind regards
From: Guillaume Lelarge <guillaume@lelarge.info>
To: salah jubeh <s_jubeh@yahoo.com>
Cc: pgsql <pgsql-general@postgresql.org>
Sent: Thursday, August 18, 2011 10:48 PM
Subject: Re: [GENERAL] Pgadmin plugins
On Thu, 2011-08-18 at 08:22 -0700, salah jubeh wrote:
> Hello,
>
> I find pgadmin a nice software, but I think it lacks some fundamental
> functionalities mainly repositories support including git and cvs.
I also do think pgAdmin lacks some nice features, but repository
support, I don't even understand what you want :)
> Also, some enhancement on the editor would be nice such as auto completion
Already in it.
> , code ordering,
Which means?
> coloring
Already has it.
> , etc. I have seen that pgadmin have a menu called plugins, what is it for ?
To launch tools. The most obvious ones are psql or pg_dump, but every
tool you could imagine. IIRC, the PostGIS guys did a nice plugin (a
shapefile loader, I guess).
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
On Thu, 2011-08-18 at 15:24 -0700, salah jubeh wrote: > > Hello, > > I need repository plug in in order to control my DDL, currently I am using text files to create sachems, procedures , etc. and it will be great if I can keep track of how the schema changes and even to protect against errors such as accidentalfile deletion. > I don't think it belongs to pgAdmin. You can use any of the usual tools to do it for you. Like tortoiseCVS and tortoiseGit on Windows. > Regarding code ordering , I mean indentation and order the sql code to make it more readable. this can found in all Integrateddevelopment environments for c++, and java. > This is something I've been asked for. So hard I didn't even try :) > regarding the plug in you are right I am using an old version so the psql console is not there, but is there away to enablerepository plug in and get the text file in the Pgadmin editor. > I don't think so. The only thing you can do is to create some plugins with a specific action in each. For example, one plugin to go in your repository, and launch "git pull". Another one to go in your repository, and launch "git commit". I think it will be harder to configure and use, than to use one of the tortoise tools. And, please, don't top-post. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com