Re: Import file into bytea field in SQL/plpgsql? - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Import file into bytea field in SQL/plpgsql?
Date
Msg-id 5ded07e00803050820t69167fb9qa9b6e4da2f632e0a@mail.gmail.com
Whole thread Raw
In response to Re: Import file into bytea field in SQL/plpgsql?  (Erwin Brandstetter <brsaweda@gmail.com>)
List pgsql-general
On 3/5/08, Erwin Brandstetter <brsaweda@gmail.com> wrote:
>  The whole concept behind large objects is a bit off. Since we have
>  TOAST tables, it is of limited use to store large objects away in a
>  system table. It would be useful to have (additional) functions like:
>    lo_import(text) RETURNS bytea
>    lo_export(bytea, text) RETURNS integer

Just so you know, large objects are quite old and predate TOAST, which
is why they are slightly quirky.  I agree that import/export functions
for BYTEA would be useful.


--
-Doug

pgsql-general by date:

Previous
From: Erwin Brandstetter
Date:
Subject: Re: Import file into bytea field in SQL/plpgsql?
Next
From: tv@fuzzy.cz
Date:
Subject: Re: indexing - creates problem