| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Aram Fingal <fingal(at)multifactorial(dot)com> |
| Cc: | Postgres-General General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: crosstab |
| Date: | 2012-09-04 21:06:35 |
| Message-ID: | 50466D5B.3060101@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/04/2012 01:23 PM, Aram Fingal wrote:
> So then, PL/R is not a solution to being able to pivot tables
> directly in PostgreSQL but I might be able to define a PL/R procedure
> which, for example, pivots tables and then uses the write.table()
> function of R to send the results to disk without returning any rows
> to PostgreSQL? Such a procedure might prove be faster and more
> convenient than extracting the data from PostgreSQL into an R
> application layer and then writing to disk.
As mentioned somewhere else along this thread, I don't know that it will
be faster, but it may well be more convenient if your goal is to get a
CSV file in the end anyway.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2012-09-04 21:13:09 | Re: "Too far out of the mainstream" |
| Previous Message | Merlin Moncure | 2012-09-04 20:56:02 | Re: crosstab |