Re: Import file into bytea field in SQL/plpgsql?

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: "Erwin Brandstetter" <brsaweda(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Import file into bytea field in SQL/plpgsql?
Date: 2008-03-05 16:20:58
Message-ID: 5ded07e00803050820t69167fb9qa9b6e4da2f632e0a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/5/08, Erwin Brandstetter <brsaweda(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ralph Smith 2008-03-05 18:28:19 Requiring a password
Previous Message tv 2008-03-05 16:15:26 Re: indexing - creates problem