HI all,
I see a lot of external tools that do a 'SELECT version()' and then
parse the output to get the version number (e.g., 10.4).
My opinion is that this is not a good approach, since the output of
version includes a lot of information and can mismatch a poorly
written regular expression. It wou
SHOW server_version;
SHOW server_version_num;
I can fetch the version by these two statement.
On Thu, Aug 9, 2018 at 3:01 PM Luca Ferrari wrote:
> HI all,
> I see a lot of external tools that do a 'SELECT version()' and then
> parse the output to get the version number (e.g., 10.4).
> My opinio
Hi,
I'm looking for the package of postgresql-x-pldebugger for alpine Linux
distribution.
I found the package for Ubtuntu 18.04LTS on this link
https://packages.ubuntu.com/bionic/postgresql-10-pldebugger but it does not
exist in Alpine Linux
https://pkgs.alpinelinux.org/packages?name=postgresql-pld
=?UTF-8?B?V8OoaSBDxY1uZ3J1w6w=?= writes:
> On Thu, Aug 9, 2018 at 3:01 PM Luca Ferrari wrote:
>> Is there any way to get directly the PostgreSQL version number?
> SHOW server_version;
> SHOW server_version_num;
Also, if you're using libpq, see PQserverVersion() which
(a) avoids a round trip to
On Sun, Jul 1, 2018 at 07:09:33PM -0700, Clifford Snow wrote:
> Vic,
> I'd be happy to add my blog to planet.postgresql.org but my of my articles are
> not on postgresql. I'm using github pages for my blog and I do have tags for
> each article. Is there someone to filter on those tags?
When you
On Tue, Jul 3, 2018 at 05:00:17PM -0400, Tom Lane wrote:
> Thomas Kellerer writes:
> > A recent discussion around timestamptz behaviour has lead me to question my
> > own understanding on how a TIMESTAMPTZ is converted to the session's time
> > zone.
> > I assumed this conversion happens *on th
On 08/09/2018 01:49 PM, Bruce Momjian wrote:
On Tue, Jul 3, 2018 at 05:00:17PM -0400, Tom Lane wrote:
Thomas Kellerer writes:
A recent discussion around timestamptz behaviour has lead me to question my own
understanding on how a TIMESTAMPTZ is converted to the session's time zone.
I assumed
On Mon, Jul 16, 2018 at 11:57:40AM +0200, Vincenzo Campanella wrote:
> Il 16.07.2018 11:41, Albrecht Dreß ha scritto:
> >Am 16.07.18 00:14 schrieb(en) Tim Cross:
> >>>Thank you for the point. I'm the C++ programmer and I'm author of the
> >>>C++ client library for PostgreSQL - Pgfe and I'm going to
