select version () gives me output something like this PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red hat 4.1.2-55), 64 bit.
Is there any other way to find On 07-Jul-2017 7:28 PM, "Adrian Klaver" <adrian.kla...@aklaver.com> wrote: > On 07/07/2017 06:52 AM, Krithika Venkatesh wrote: > >> Hi, >> >> I have postgreSQL 9.5 installed in the server. Is it possible to find >> whether the installed postgresql is enterprise db or an open source version >> through a query. >> > > Not sure, but I would try: > > select version(); > > >> Thanks in Advance. >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
