Thread: getting the version
Hello. A library i wrote (bonddb) does a lot of work at extracting backend information from postgresql, like how the database was created etc. Anyway, I've got a few problems with changes in the change of structure from 7.1 to 7.2. Is there a table/field i can query to get what version of the database the user currently has without reading the PG_VERSION file?
SELECT version(); Regards, Dave. > -----Original Message----- > From: Andrew Hill [mailto:andru@treshna.com] > Sent: 16 April 2002 13:26 > To: pgadmin-hackers@postgresql.org > Subject: [pgadmin-hackers] getting the version > > > Hello. > > A library i wrote (bonddb) does a lot of work at extracting backend > information from postgresql, like how the database was created etc. > Anyway, I've got a few problems with changes in the change > of structure > from 7.1 to 7.2. Is there a table/field i can query to get > what version > of the database the user currently has without reading the > PG_VERSION file? > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org >
Dave Page wrote: >SELECT version(); > >Regards, Dave. > Thanks man, i knew it had to be something easy like that. > > >>-----Original Message----- >>From: Andrew Hill [mailto:andru@treshna.com] >>Sent: 16 April 2002 13:26 >>To: pgadmin-hackers@postgresql.org >>Subject: [pgadmin-hackers] getting the version >> >> >>Hello. >> >>A library i wrote (bonddb) does a lot of work at extracting backend >>information from postgresql, like how the database was created etc. >> Anyway, I've got a few problems with changes in the change >>of structure >>from 7.1 to 7.2. Is there a table/field i can query to get >>what version >>of the database the user currently has without reading the >>PG_VERSION file? >> >> >> >> >> >>---------------------------(end of >>broadcast)--------------------------- >>TIP 1: subscribe and unsubscribe commands go to >>majordomo@postgresql.org >> > >