On 7/7/2017 8:22 AM, Terry Schmitt wrote:
You have the open source version installed. Now where it was installed
from is a different story.
if its a redhat/centos/fedora type system, try...
rpm -qa |grep ^postgres
if it was installed from rpm's, the full names of the rpms will clue you i
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
On Fri, Jul 7, 2017 at 9:04 AM, Krithika Venkatesh <
krithikavenkates...@gmail.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/07/2017 07:04 AM, Krithika Venkatesh 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
It depends on what you are trying to determine:
On Fri, Jul 7, 2017 at 7:04 AM, Krithika Venkatesh <
krithikavenkates...@gmail.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
>
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" wrote:
> On 07/07/2017 06:52 AM, Krithika Venkatesh 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.
--
A
