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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>