Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
i want to extract data from table: product_template field "name" where data is in json format, i want to extract portion of data as below (2nd screenshot) in blue rectangle (without double quotes " ), please help how i can do it?
i am using PgAdmin4, here are 2 screenshots:
regards
Hi,
Please try this query,
SELECT name ->> 'en_US' AS product_name FROM product_template;
Output:
Thanks
thanks for help... it works fine.
but, as mentioned, i want it without double quotes " ... how to remove it?
regards
I have updated the answer, please check
thanks a bunch!!! brillieant !! it saves to write a function. i thought i have to write a function and use replace function to eliminate double quotes.
regards
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
1
thg 5 25
|
2440 | ||
|
1
thg 4 25
|
3461 | ||
|
1
thg 4 25
|
4281 | ||
|
1
thg 4 25
|
1770 | ||
|
4
thg 3 25
|
6872 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
