lundi 2 février 2015

Postgres multiple columns to json


I am running postgresql 9.3.4. I have a table with 3 fields:



id name addr
--- ---- ----
1 n1 ad1
2 n2 ad2
...


I need to move the data to a new table with fields like:



id data
--- ----
1 {'name': 'n1', 'addr': 'ad1'}
2 {'name': 'n2', 'addr': 'ad2'}
...


row_to_json is not the solution for me as SELECT t.id, row_to_json(t) as data FROM (select id, name, addr from myt) t adds id to the as well. Is there a way to choose the fields I need (name & addr) in my data field?





Aucun commentaire:

Enregistrer un commentaire