Re: Postgresql - commercial version

You have the open source version installed. Now where it was installed from
is a different story.

EnterpriseDB Advanced Server will look like:
EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-16), 64-bit

T

On Fri, Jul 7, 2017 at 7:04 AM, Krithika Venkatesh <
krithikavenkatesh31(at)gmail(dot)com> wrote:

> 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
>>
>