On 4/6/05 9:18 pm, "Joe Conway" <[EMAIL PROTECTED]> wrote:
> Gabor Grothendieck wrote:
>> On 6/4/05, Adam Witney <[EMAIL PROTECTED]> wrote:
>>> I am using PL/R in PostgreSQL amd have written some functions to build my
>>> data frame. However this can take some time with some large datasets and I
>>> would like to not have to repeat the process and so I would like to save the
>>> data frame. Rather than save/load into the file system I would like to be
>>> able to save the entire data frame as a single object in the database
>>>
>>> Is this possible?
>>
>> Check out ?serialize
>
> Looks like serialize should work nicely:
>
> create or replace function test_serialize(text)
> returns text as '
> mydf <- pg.spi.exec(arg1)
> return (serialize(mydf, NULL, ascii = TRUE))
> ' language 'plr';
>
> create table saved_df (id int, df text);
>
> insert into saved_df
> select 1, f from test_serialize('select oid, typname from pg_type
> where typname = ''oid''
> or typname = ''text''') as t(f);
>
> create or replace function restore_df(text)
> returns setof record as '
> unserialize(arg1)
> ' language 'plr';
>
> select * from restore_df((select df from saved_df where id =1))
> as t(oid oid, typname name);
> oid | typname
> -----+---------
> 25 | text
> 26 | oid
> (2 rows)
>
> HTH,
That looks great Joe, Gabor. Thanks for your help.
Cheers
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
