Can I return JSON objects without explicit aliasing in postgres?
If I have two tables and I join them, can I return one of the values a JSON object, without having to specify all the fields?
postgres – How to parse json array elements?
Below is the table table1
: