From: | Willian Jhonnes <willianjhonnes(at)gmail(dot)com> |
---|---|
To: | pgsql-pt-geral(at)lists(dot)postgresql(dot)org |
Subject: | "Explodir" um JSON Array em recordset |
Date: | 2018-10-24 14:38:45 |
Message-ID: | CALj9=jiTbmU+oKTKzig1A2FpetOO=Gkc_MPGjuayy3O5BQSKcg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pt-geral |
Bom dia a todos.
Em certa tabela, tenho um campo jsonb que contem o seguinte array:
[{"usuario":"pedrobase","data":"08\/10\/2018
14:02:34","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:38","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:38","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:39","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:39","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:48","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:49","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:49","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:49","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:49","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:49","comentario":""},{"usuario":"pedrobase","data":"08\/10\/2018
14:02:50","comentario":""}]
Preciso explodí-lo em um recordset como este:
usuario |data |comentario
----------+-------------------+----------
pedrobase |08/10/2018 14:02:34|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:38|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:38|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:39|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:39|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:48|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:49|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:49|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:49|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:49|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:49|
----------+-------------------+----------
pedrobase |08/10/2018 14:02:50|
Em uma consulta à documentação [
https://www.postgresql.org/docs/current/static/functions-json.html] não
encontrei nada que realmente me ajudasse nesta questão.
Qual a melhor forma de obter o resultado demonstrado no exemplo?
---------------------------------------------------
Att.:
Willian Jhonnes L. dos Santos
Object/Free Pascal Analyst/Developer
PHP Analyst/Developer
willianjhonnes(at)gmail(dot)com
---------------------------------------------------
Only those who will risk going too far can possibly find out how far one
can go. - T. S. Eliot
Computing Engineering - PUC-PR
Be free. Use Linux.
São José dos Pinhais GNU/Linux User Group
Linux user number 449753
---------------------------------------------------
Powered by Slackware Linux 14.2 64 bits
Kernel 4.4.38-x86_64-iCore
---------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas | 2018-10-24 15:59:04 | Re: "Explodir" um JSON Array em recordset |
Previous Message | Osvaldo Kussama | 2018-10-24 14:02:14 | Re: Histórico da lista pgbr fora do ar? |