On 03/27/2015 10:40 AM, Eli Murray wrote:
Hi All,I'm trying to create an array of JSON objects from an existing table. I've created a new table: "CREATE TABLE json(data json[]);" Now i need to populate it with key value pairs from another table. I'd like to create the objects to look like: { "code": rawdata.deptcode, "name": rawdata.deptname } But I'm having difficulty understanding the syntax to do this because I find the docs to be rather difficult to parse. I've tried running the query: "INSERT INTO json(data) json_build_object(SELECT DISTINCT deptcode, deptname AS code, name FROM rawdata);" but it returns a syntax error.
That would be? What version of Postgres?
I've also tried running: "INSERT INTO json(data) row_to_json(SELECT DISTINCT deptcode, deptname FROM rawdata);" but no dice. Does anyone know the proper syntax to create an array of JSON objects from an existing table?
json_build_array? http://www.postgresql.org/docs/9.4/interactive/functions-json.html
-- Senior Web Developer at The Daily Illini ejmur...@illinimedia.com <mailto:ejmur...@illinimedia.com> (815) 985-8760
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
