From: | Miroslav Beranič <miroslav(dot)beranic(at)mibesis(dot)si> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | pgeu-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Query jsonb, integer array, uuid using libpq |
Date: | 2019-07-13 11:45:25 |
Message-ID: | CA+3Fds6GO0okimhROoTBXmTUAPiLNnfCQH9rTU5fWCkDiOq45A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgeu-general |
Hi,
I am using libpq, recent version. Uuid is in binary formart ( byte array )
and also array is in some kind od byte array, single element in one
dimension array consumes 28 places ( field length reported from libpq ).
Is there a util library, that is able to parse this data formats or some
kind of documentation.
I've found out that jsonb is as string, so for now uuid and integer[] are
only unknowns.
Kind regards,
Miroslav
V sob., 13. jul. 2019 13:34 je oseba Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
napisala:
> On Fri, 2019-07-12 at 19:35 +0200, Miroslav Beranič wrote:
> > I am trying to fetch uuid and integer array using libpq. PG versions 10,
> 11, 12 ( eather).
> >
> > Is there there any documentation, blog, book that I can take a look at?
>
> Sure, https://www.postgresql.org/docs/current/libpq.html
>
> They work just like all other data types.
>
> Get them in text mode, and they will show up in their string
> representation.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2019-07-31 16:31:26 | 2019 General Assembly Minutes |
Previous Message | Laurenz Albe | 2019-07-13 11:34:02 | Re: Query jsonb, integer array, uuid using libpq |