Postgres return JSON element

Question

I have a JSON field ('ez_links') in a table ('bookings') and I wish to return a particular attribute/element ('Amount'), which represents the price of the booking.

In the example below, I want to return the value of '662', but NULL is returned.

select ez_links, ez_links-> 'Amount' AS price
FROM bookings
limit 1

Result:

ez_links	price
{"integrator": "ezlinks", "TeeTimeReserveRecord": {"Fee": "Troon App Member", "Amount": "662",...........................................}}	NULL

Thanks for your help.

kartikey rajvaidya · Accepted Answer · 2022-10-28 07:27:39Z

2

This is a nested JSON, you can do the following to access the Amount field

SELECT ez_links->'TeeTimeReserveRecord'->'Amount' as price FROM bookings
limit 1                                                                                                                  ;

I hope this was helpful.

answered Oct 28, 2022 at 7:27

kartikey rajvaidya

1011 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres return JSON element

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related