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: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of leoabhi [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
