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

Re: Is Changing database Name possible ?

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: Is Changing database Name possible ?
Date: 2008-04-08 12:37:32
Message-ID: 47FB670C.70509@nsoft.lt (view raw or flat)
Thread:
Lists: pgadmin-support
Hi,

backup, create a new DB with the name you want and then restore data 
into it.

-- 
Julius Tuskenis



leoabhi rašė:
> 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
>>
>>
>>     
>
>   



In response to

pgadmin-support by date

Next:From: Melvin DavidsonDate: 2008-04-08 12:54:55
Subject: Re: Is Changing database Name possible ?
Previous:From: leoabhiDate: 2008-04-08 12:30:21
Subject: Is Changing database Name possible ?

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