Re: nested xml/json to table

From: Wim Bertels <wim(dot)bertels(at)ucll(dot)be>
To: "shammat(at)gmx(dot)net" <shammat(at)gmx(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: nested xml/json to table
Date: 2023-03-17 11:04:42
Message-ID: 0d59af8d8b855c8f97796e611280b993ee261f7f.camel@ucll.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 down the three, using null
> > for
> > empty values, adding more columns as needed by the given structure.
> > (1-way operation)
>
>
> You can't have a function that returns a different set of columns
> each time you call it
> (without specifying the output columns - which you don't want).

Hello Thomas,

thanks for the feedback,
i was wondering in the likes of existing built-in functions or
extensions (not CREATE FUNCTION)

mvg,
Wim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2023-03-17 11:06:05 Re: Delete values from JSON
Previous Message Romain MAZIÈRE 2023-03-17 10:56:22 Re: Delete values from JSON