Most voted "jsonb" questions

None

• 1

  votes

  1

  answer

  747

  views

  Problems with encoding in Database Query

  When trying to execute a SELECT, using fields that store data in the JSON structure, I see a problem with the data that may come: SELECT tbl_pf.nome, tbl_pf.adicionais::JSONB->'recebeTaxa' AS…

  postgresql character-encoding jsonb

  asked 6 years, 6 months ago William Aparecido Brandino 848

• 1

  votes

  2

  answers

  55

  views

  Postgresql change an element of a JSON column

  Hello, I’m trying to change a JSON column, but I want to change only one element, in this case, the "url". There are some urls that have the symbols ' ' and '$' at the beginning and end, as below:…

  database json postgresql sql-update jsonb

  asked 3 years, 9 months ago Diogo Zucchi 33

• -2

  votes

  1

  answer

  21

  views

  Select in nested jsonb - postgresql

  I had difficulty finding the values on a basis, as all examples cite the same way to find information in simple jsons. But a friend from work passed me and solution and I came to share. the initial…

  json postgresql jsonb

  asked 4 years, 3 months ago Luciano Gonçalves 474