Обсуждение: Feature Request: Rename DB in pgAdmin

Hi,

Another feature request:
I would like to be able to rename a database by right clicking on a database and choosing Rename from the context menu
(whichdoes not exist right now).
 

I know I can do the same thing by opening a query window and writing a ALTER DATABASE ... RENAME TO ...
command, but that would seems a nice command to have (particularly when developing and moving database around).
Have fun,
L@u
The Computing Froggy



     _____________________________________________________________________________ 
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail 

Laurent ROCHE a écrit :
> Another feature request:
> I would like to be able to rename a database by right clicking on a database and choosing Rename from the context
menu(which does not exist right now).
 
> 
> I know I can do the same thing by opening a query window and writing a ALTER DATABASE ... RENAME TO ...
> command, but that would seems a nice command to have (particularly when developing and moving database around).
>  

I first thought it would be easy to do with the properties dialog.
Unfortunately, it's more like a nightmare. You need to be the owner and
you need to have the CREATEDB privilege. Moreover, nobody must be
connected to it. Right click on it and pgAdmin launch a connection on it
(if it wasn't already done).

It really is more hard that I previously thought :) It does not seem
feasible right now.


-- 
Guillaume.
<!-- http://abs.traduc.org/    http://lfs.traduc.org/    http://docs.postgresqlfr.org/ -->

Laurent ROCHE wrote:
> Hi,
> 
> Another feature request:
> I would like to be able to rename a database by right clicking on a database and choosing Rename from the context
menu(which does not exist right now).
 
> 
> I know I can do the same thing by opening a query window and writing a ALTER DATABASE ... RENAME TO ...
> command, but that would seems a nice command to have (particularly when developing and moving database around).
>

This is already on the todo list because it's a non-trivial problem:
http://www.pgadmin.org/development/todo.php

Patches are welcome.

Regards, Dave