İçereği Atla
Bu soru işaretlendi
pgadminodoo16features
1 Cevapla
4570 Görünümler
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
Vazgeç
Avatar
Savya Sachin
En İyi Yanıt

Hi,

Please try this query,

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

Output:


Thanks

Avatar
Vazgeç
SmithJohn45
Üretici

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
Üretici

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

İlgili Gönderiler Cevaplar Görünümler Aktivite
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Çözüldü
odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
5
Eyl 25
24653
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
Ağu 25
3760
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
May 25
3667
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
Nis 25
4512
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
Nis 25
5361