Re: Is Changing database Name possible ?

Abhi,

1st.,  the word is Hello, not Hallo!

Next, PgAdmin does allow you to change the name, but you cannot have a current connection to that same database.

Steps to do this.
1. Right click the Databases branch and select refresh.
2. Click on database postgres and then open a Query window.
3. ALTER DATABASE "<OldName> " RENAME TO <new_name>;

Note that the Old Name MUST BE enclosed in quotes.

________________________________________
From: pgadmin-support-owner@postgresql.org [pgadmin-support-owner@postgresql.org] On Behalf Of leoabhi
[abhishekrm@gmail.com]
Sent: Tuesday, April 08, 2008 6:30 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Is Changing database Name possible ?

Hallo,
Thanks for your reply. It helped and worked.

I tried to change the name of Database to small letters, but Pgadmin doesnt
allow me to do so or i failed to figure it out ?

Any suggestions  how i can replace my existing database with a new name ?

thanks
Rgrds,
Abhi



Melvin Davidson-3 wrote:
>
> Hello Abhi,
>
> It seems to me that a datatype of real[] would be appropriate.
> Alternative syntax is real ARRAY[3]
>
> http://www.postgresql.org/docs/8.2/interactive/arrays.html#AEN5738
>
>
> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of leoabhi
> Sent: Monday, April 07, 2008 3:33 AM
> To: pgadmin-support@postgresql.org
> Subject: Re [pgadmin-support] pgadmin datatype
>
>
> Hallo,
>
>  I want to make a column which will store (x,y,z) cordinates
> Eg(2.12 , -3.00012 , 5.2132)
>
> Is there any inbuilt datatype for Pgadmin III??
>
> Please reply with your suggestions
> thanks
>
>
> Abhi
>
>
>
> --
> View this message in context:
> http://www.nabble.com/Re-pgadmin-datatype-tp16536685p16536685.html
> Sent from the PostgreSQL - pgadmin support mailing list archive at
> Nabble.com.
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>

--
View this message in context: http://www.nabble.com/Re-pgadmin-datatype-tp16536685p16558111.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


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