Support Questions
Find answers, ask questions, and share your expertise

PostgreSQL 5 tables data in to single JSON

PostgreSQL 5 tables data in to single JSON

New Contributor

Sample output JSON:
{
loginname:"loginname",
loginid:123,
name:{
fname:"firstname",
lname:"lastname",
mname:"middlename"
},
lastlogin:"date",
status:1
}