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

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: Import file into bytea field in SQL/plpgsql?
Дата
Msg-id 5ded07e00803050820t69167fb9qa9b6e4da2f632e0a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Import file into bytea field in SQL/plpgsql?  (Erwin Brandstetter <brsaweda@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Erwin Brandstetter
Дата:
Сообщение: Re: Import file into bytea field in SQL/plpgsql?
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: indexing - creates problem