Thread: Re 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.
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@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] 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
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@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] 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.
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@postgresql.org >> [mailto:pgadmin-support-owner@postgresql.org] 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 >> >> >> > >
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@postgresql.org [pgadmin-support-owner@postgresql.org] On Behalf Of leoabhi [abhishekrm@gmail.com] 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: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] 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