Skip to Content
This question has been flagged
pgadminodoo16features
1 Respondre
3751 Vistes
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
Descartar
Avatar
Savya Sachin
Best Answer

Hi,

Please try this query,

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

Output:


Thanks

Avatar
Descartar
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 Respostes Vistes Activitat
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
d’ag. 25
2693
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
de maig 25
2683
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
d’abr. 25
3673
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
d’abr. 25
4525
Favicons not working with Bing
odoo16features
Avatar
Avatar
1
d’abr. 25
1987