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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
