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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

  From Date Subject
Next Message Melvin Davidson 2008-04-08 12:54:55 Re: Is Changing database Name possible ?
Previous Message leoabhi 2008-04-08 12:30:21 Is Changing database Name possible ?