Thread: Pgadmin plugins

Pgadmin plugins

From
salah jubeh
Date:
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


 

Re: Pgadmin plugins

From
Guillaume Lelarge
Date:
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


Re: Pgadmin plugins

From
salah jubeh
Date:

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



Re: Pgadmin plugins

From
Guillaume Lelarge
Date:
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