Re: [GENERAL] Design ? table vs. view?

2014-07-16 Thread Rémi Cura
Hey, I guess you know all about PL/R, the R language extension for postgres . It is very convenient, though be carefull as sometime it crashed my server. Cheers, Rémi-C 2014-07-16 3:42 GMT+02:00 John McKown : > On Tue, Jul 15, 2014 at 8:46 AM, David G Johnston < > david.g.johns...@gmail.com> wr

Re: [GENERAL] Design ? table vs. view?

2014-07-15 Thread John McKown
On Tue, Jul 15, 2014 at 8:46 AM, David G Johnston < david.g.johns...@gmail.com> wrote: > John McKown wrote > > I have a table which has some "raw" data in it. By "raw", I mean it is > > minimally processed from a log file. Every week, I update this table by > > processing the weekly log using awk

Re: [GENERAL] Design ? table vs. view?

2014-07-15 Thread David G Johnston
John McKown wrote > I have a table which has some "raw" data in it. By "raw", I mean it is > minimally processed from a log file. Every week, I update this table by > processing the weekly log using awk to create a "psql script" file which > looks similar to: > > COPY rawdata FROM STDIN; > li

[GENERAL] Design ? table vs. view?

2014-07-15 Thread John McKown
I have a table which has some "raw" data in it. By "raw", I mean it is minimally processed from a log file. Every week, I update this table by processing the weekly log using awk to create a "psql script" file which looks similar to: COPY rawdata FROM STDIN; lines created by awk script \. Th