Re: Toast and slice of toast - Mailing list pgsql-general

From Haribabu Kommi
Subject Re: Toast and slice of toast
Date
Msg-id CAJrrPGdb3=gg+cG3Lm_fz_j0R9yW2ddTmkSBvJcUEzn2Xspo4g@mail.gmail.com
Whole thread Raw
In response to Toast and slice of toast  (Rémi Cura <remi.cura@gmail.com>)
Responses Re: Toast and slice of toast  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-general
On Sun, Feb 16, 2014 at 9:38 PM, Rémi Cura <remi.cura@gmail.com> wrote:
Hey Dear List,
could somebody point me to some ressources about getting only parts of toasted data?

I have a very big custom type and I would like to take blocks of it (like byte A to B then byte C to D  then... ).

I found a function in http://doxygen.postgresql.org/tuptoaster_8c.html# called toast_fetch_datum_slice, is it the right way to use it
(a for loop and calling it several time?).

"pg_detoast_datum_slice" is the function which will solve your problem.
 
Regards,
Hari Babu
Fujitsu Australia

pgsql-general by date:

Previous
From: Ondřej Bouda
Date:
Subject: Using pg_trigger.tgqual
Next
From: Gabriel Sánchez Martínez
Date:
Subject: avoiding file system caching of a table