Re: [GENERAL] Building JSON objects

2015-03-27 Thread Eli Murray
to in Javascript and wrote it to a file that I serve from my server when users request it. Thanks again! On Fri, Mar 27, 2015 at 1:49 PM, Jan de Visser wrote: > On March 27, 2015 11:38:42 AM David G. Johnston wrote: > > On Fri, Mar 27, 2015 at 11:31 AM, Jan de Visser > wrote: > &g

Re: [GENERAL] Building JSON objects

2015-03-27 Thread Eli Murray
on table." I could do it in javascript or python but I'm pretty green when it comes to SQL. I know it's probably simple, but I'm having a hell of a time trying to figure it out. Anyway, thanks for the suggestion and letting me rubber duck debug off of you. On Fri, Mar 27, 2

[GENERAL] Building JSON objects

2015-03-27 Thread Eli Murray
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.d

Re: [GENERAL] Creating composite keys from csv

2015-03-09 Thread Eli Murray
onid = assignid.personid WHERE rawdata.employeename && rawdata.totalsalary = assignid.name && assignid.totalsalary? On Mon, Mar 9, 2015 at 8:36 AM, Adrian Klaver wrote: > On 03/08/2015 08:49 PM, Eli Murray wrote: > >> Hi all, >> >> I'm a student journalist worki

[GENERAL] Creating composite keys from csv

2015-03-08 Thread Eli Murray
o put it succinctly, how would you approach this problem? What are our options? Do we need to write a script to clean the data into separate csv tables before we import it to postgres, or is this something we can do in postgres? We'd really appreciate any help you all may be able to offer. Best! Eli Murray