Skip site navigation (1) Skip section navigation (2)

Re: Is Changing database Name possible ?

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 (view raw or flat)
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

In response to

pgadmin-support by date

Next:From: Fernando HeviaDate: 2008-04-08 13:01:44
Subject: Re: Removing Context Messages
Previous:From: Julius TuskenisDate: 2008-04-08 12:37:32
Subject: Re: Is Changing database Name possible ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group