Skip to Content
This question has been flagged
pgadminodoo16features
1 Odpoveď
3753 Zobrazenia
Avatar
SmithJohn45

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


 

Avatar
Zrušiť
Avatar
Savya Sachin
Best Answer

Hi,

Please try this query,

SELECT name ->> 'en_US' AS product_name FROM product_template;

Output:


Thanks

Avatar
Zrušiť
SmithJohn45
Autor

thanks for help... it works fine.
but, as mentioned, i want it without double quotes " ... how to remove it?
regards

Savya Sachin

I have updated the answer, please check

SmithJohn45
Autor

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

Related Posts Replies Zobrazenia Aktivita
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
aug 25
2693
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
máj 25
2683
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
apr 25
3673
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
apr 25
4525
Favicons not working with Bing
odoo16features
Avatar
Avatar
1
apr 25
1987