From: | Melvin Davidson <mdavidson(at)trenstar(dot)com> |
---|---|
To: | leoabhi <abhishekrm(at)gmail(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Is Changing database Name possible ? |
Date: | 2008-04-08 12:54:55 |
Message-ID: | 5CA4D07E8D52ED4AB5499CA4E089858110A0A4772B@star2.corp.trenstar.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)postgresql(dot)org [pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of leoabhi [abhishekrm(at)gmail(dot)com]
Sent: Tuesday, April 08, 2008 6:30 AM
To: pgadmin-support(at)postgresql(dot)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(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of leoabhi
> Sent: Monday, April 07, 2008 3:33 AM
> To: pgadmin-support(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Hevia | 2008-04-08 13:01:44 | Re: Removing Context Messages |
Previous Message | Julius Tuskenis | 2008-04-08 12:37:32 | Re: Is Changing database Name possible ? |