Re: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows!

On 2023-03-16 20:24:49 +0100, Laurenz Albe wrote: > On Thu, 2023-03-16 at 13:20 +, Dolan, Sean wrote: > > I messed up and confused issues.   The error is :  > > ERROR: Could not extend pg_tblspc/16555/PG_13_20200//  No space > > left on device > > HINT: Check free disk space > > > >

Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?

On 2023-03-16 11:52:47 +0100, Dominique Devienne wrote: > On Thu, Mar 16, 2023 at 11:15 AM Pavel Stehule > wrote: > čt 16. 3. 2023 v 9:55 odesílatel Dominique Devienne > napsal: > That's a nice way to put it Pavel. > And to have it both ways, use COPY in binary protocol?

Re: src/test/examples/testlibpq2.c where the HAVE_SYS_SELECT_H is defined.

Yes, you are right. my mistake. I should choose the manual dev version. On Fri, Mar 17, 2023 at 4:12 PM Thomas Munro wrote: > On Fri, Mar 17, 2023 at 7:48 PM jian he > wrote: > > Hi, > > playing around with $[0] testlibpq2.c example. I wondered where > HAVE_SYS_SELECT_H is defined? > > > > I

Re: Delete values from JSON

På fredag 17. mars 2023 kl. 11:56:22, skrev Romain MAZIÈRE < romain.mazi...@sigmaz-consilium.fr >: Hi, If it is jsonb type, you can have a look at the documentation : https://www.postgresql.org/docs/14/functions-json.html

Re: nested xml/json to table

Thomas Kellerer schreef op vr 17-03-2023 om 11:21 [+0100]: > Wim Bertels schrieb am 17.03.2023 um 11:05: > > what would be the general idea: "easily" convert an hierarchical > > structure like json or xml to a table; for example creating columns > > by > > appending the key-names when going doing

Re: Delete values from JSON

Hi, If it is jsonb type, you can have a look at the documentation : https://www.postgresql.org/docs/14/functions-json.html There are some examples : |jsonb| |-| |text| → |jsonb| Deletes a key (and its value) from a JSON object, or matching string value(s) from a JSON array. |'{"a": "b",

Re: src/test/examples/testlibpq2.c where the HAVE_SYS_SELECT_H is defined.

On Fri, Mar 17, 2023 at 7:48 PM jian he wrote: > Hi, > playing around with $[0] testlibpq2.c example. I wondered where > HAVE_SYS_SELECT_H is defined? > > I searched on the internet, founded that people also asked the same question > in $[1]. > > In my machine, I do have . > system version:

Re: nested xml/json to table

Wim Bertels schrieb am 17.03.2023 um 11:05: > what would be the general idea: "easily" convert an hierarchical > structure like json or xml to a table; for example creating columns by > appending the key-names when going doing down the three, using null for > empty values, adding more columns as

nested xml/json to table

Hello, in python pandas there is for example a json_normalize function, i didn't find something similar or better in postgresql? what would be the general idea: "easily" convert an hierarchical structure like json or xml to a table; for example creating columns by appending the key-names when

Delete values from JSON

Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN": { "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6", "details": [ { "keyInformation": { "dunsNumber": "NaN", "organizationType": "LIMITED_COMPANY" } }, { "keyInformation": { "dunsNumber": "123", "organizationType":

src/test/examples/testlibpq2.c where the HAVE_SYS_SELECT_H is defined.

Hi, playing around with $[0] testlibpq2.c example. I wondered where HAVE_SYS_SELECT_H is defined? I searched on the internet, founded that people also asked the same question in $[1]. In my machine, I do have . system version: Ubuntu 22.04.1 LTS gcc version: gcc (Ubuntu 11.3.0-1ubuntu1~22.04)