Ggtcf

Why is Collection not simply treated as Collection<?>

How to model explosives?

Is it possible to download Internet Explorer on my Mac running OS X El Capitan?

Will google still index a page if I use a $_SESSION variable?

Is there a hemisphere-neutral way of specifying a season?

What is the word for reserving something for yourself before others do?

Fully-Firstable Anagram Sets

Do I have a twin with permutated remainders?

What killed these X2 caps?

Combinations of multiple lists

Alternative to sending password over mail?

Did Shadowfax go to Valinor?

Why is consensus so controversial in Britain?

In Romance of the Three Kingdoms why do people still use bamboo sticks when papers are already invented?

How do conventional missiles fly?

Can a virus destroy the BIOS of a modern computer?

How can I tell someone that I want to be his or her friend?

Why are electrically insulating heatsinks so rare? Is it just cost?

Is "remove commented out code" correct English?

How badly should I try to prevent a user from XSSing themselves?

Is delete *p an alternative to delete [] p?

If human space travel is limited by the G force vulnerability, is there a way to counter G forces?

1960's book about a plague that kills all white people

Why does Arabsat 6A need a Falcon Heavy to launch

postgres query to update json field

postgres: upgrade a user to be a superuser?Querying inside Postgres JSON arraysHow to compare dates in datetime fields in Postgresql?Updating json field in PostgresQuery for array elements inside JSON typeSqlAlchemy(Flask+Postgres) : How to update only a specific attribute of a json field?Postgres queries for JSON ArrayPostgres - update a table with a queryUsage of FOR UPDATE in window function - PostgresQuery for JSON[] type in postgres

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

In PostgreSQL databse, I have a table called hotel, which has a column called hotel_info. This hotel_info column stores json object like below

"hotel":
 "room_details":
 "customer_detail":
 "first_name" : "aaa"
 
 

I need an update query to update value for the 'first_name' field in 'hotel_info' column. please help me to build query for this.

Thanks in advance!

postgresql postgresql-9.1 postico

share|improve this question

asked Mar 8 at 23:31

Thangakumar DThangakumar D

142316

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  There is no JSON type in 9.1. Upgrade to Postgres 11, especially that the 9.1 version is no longer supported.
  
  – klin
  Mar 9 at 2:09
  

  
  
  
  

add a comment | 

0

In PostgreSQL databse, I have a table called hotel, which has a column called hotel_info. This hotel_info column stores json object like below

"hotel":
 "room_details":
 "customer_detail":
 "first_name" : "aaa"
 
 

I need an update query to update value for the 'first_name' field in 'hotel_info' column. please help me to build query for this.

Thanks in advance!

postgresql postgresql-9.1 postico

share|improve this question

asked Mar 8 at 23:31

Thangakumar DThangakumar D

142316

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  There is no JSON type in 9.1. Upgrade to Postgres 11, especially that the 9.1 version is no longer supported.
  
  – klin
  Mar 9 at 2:09
  

  
  
  
  

add a comment | 

In PostgreSQL databse, I have a table called hotel, which has a column called hotel_info. This hotel_info column stores json object like below

"hotel":
 "room_details":
 "customer_detail":
 "first_name" : "aaa"
 
 

I need an update query to update value for the 'first_name' field in 'hotel_info' column. please help me to build query for this.

Thanks in advance!

postgresql postgresql-9.1 postico

share|improve this question

asked Mar 8 at 23:31

Thangakumar DThangakumar D

142316

"hotel":
 "room_details":
 "customer_detail":
 "first_name" : "aaa"
 
 

share|improve this question

asked Mar 8 at 23:31

Thangakumar DThangakumar D

142316

share|improve this question

asked Mar 8 at 23:31

Thangakumar DThangakumar D

142316

asked Mar 8 at 23:31

Thangakumar DThangakumar D

142316

asked Mar 8 at 23:31

Thangakumar DThangakumar D

142316

1 Answer
1

active

oldest

votes

0

Something like this should work (assuming you are on a version of Postgres that does indeed support JSON operators). Note that the 'set' function here only works on JSONB, so you may need to cast the column before/after:

SELECT JSONB_SET(
 hotel_info #> 'hotel, room_details, customer_detail'
 , 'first_name'
 , '"bbb"'
 , create_missing FALSE) AS hotel_info_modified
FROM table

Here I'm changing the name to 'bbb' for the sake of an example. Check that this is indeed the intended behaviour via a SELECT and then you can change to an UPDATE where needed.

share|improve this answer

answered Mar 9 at 20:56

rocksteadyrocksteady

17110

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072421%2fpostgres-query-to-update-json-field%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Something like this should work (assuming you are on a version of Postgres that does indeed support JSON operators). Note that the 'set' function here only works on JSONB, so you may need to cast the column before/after:

SELECT JSONB_SET(
 hotel_info #> 'hotel, room_details, customer_detail'
 , 'first_name'
 , '"bbb"'
 , create_missing FALSE) AS hotel_info_modified
FROM table

Here I'm changing the name to 'bbb' for the sake of an example. Check that this is indeed the intended behaviour via a SELECT and then you can change to an UPDATE where needed.

share|improve this answer

answered Mar 9 at 20:56

rocksteadyrocksteady

17110

add a comment | 

0

Something like this should work (assuming you are on a version of Postgres that does indeed support JSON operators). Note that the 'set' function here only works on JSONB, so you may need to cast the column before/after:

SELECT JSONB_SET(
 hotel_info #> 'hotel, room_details, customer_detail'
 , 'first_name'
 , '"bbb"'
 , create_missing FALSE) AS hotel_info_modified
FROM table

Here I'm changing the name to 'bbb' for the sake of an example. Check that this is indeed the intended behaviour via a SELECT and then you can change to an UPDATE where needed.

share|improve this answer

answered Mar 9 at 20:56

rocksteadyrocksteady

17110

add a comment | 

Something like this should work (assuming you are on a version of Postgres that does indeed support JSON operators). Note that the 'set' function here only works on JSONB, so you may need to cast the column before/after:

SELECT JSONB_SET(
 hotel_info #> 'hotel, room_details, customer_detail'
 , 'first_name'
 , '"bbb"'
 , create_missing FALSE) AS hotel_info_modified
FROM table

Here I'm changing the name to 'bbb' for the sake of an example. Check that this is indeed the intended behaviour via a SELECT and then you can change to an UPDATE where needed.

share|improve this answer

answered Mar 9 at 20:56

rocksteadyrocksteady

17110

SELECT JSONB_SET(
 hotel_info #> 'hotel, room_details, customer_detail'
 , 'first_name'
 , '"bbb"'
 , create_missing FALSE) AS hotel_info_modified
FROM table

share|improve this answer

answered Mar 9 at 20:56

rocksteadyrocksteady

17110

answered Mar 9 at 20:56

rocksteadyrocksteady

17110

answered Mar 9 at 20:56

rocksteadyrocksteady

17110