Re: Postgresql - commercial version

[John McKown <john.archie.mckown@xxxxxxxxx>]

On Fri, Jul 7, 2017 at 9:04 AM, Krithika Venkatesh <krithikavenkatesh31@xxxxxxxxx> 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

​I don't have access to EDB, just the community version (from the Fedora RPM). But from looking at the manual:

https://www.enterprisedb.com/docs/en/9.6/DB_Compat_Oracle_Reference/Database_Compatibility_for_Oracle_Developers_Reference_Guide.1.203.html

you might try:

SELECT * FROM PRODUCT_COMPONENT_VERSION;

This table does not exist in the version which I have, and so I am guessing that it would be a decent test.

--

Veni, Vidi, VISA: I came, I saw, I did a little shopping.

Maranatha! <><
John McKown