Re: Postgres blob question - insert from basic.

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема Re: Postgres blob question - insert from basic.
Дата
Msg-id 4B0A96A0.2050904@gmail.com
обсуждение исходный текст
Ответ на Postgres blob question - insert from basic.  (richard terry <rterry@pacific.net.au>)
Ответы Re: Postgres blob question - insert from basic.
Список pgsql-novice
richard terry a écrit :
> I'm confused about permissions to use lo_import/export:
...

got the same on command line as a user: must be SU to use lo_import.

but why don't U use a BYTEA (upper size limit is 1GB instead of 2GB,
but I doubt U have such large objects).

on command line, it works as a user:
INSERT INTO fruit ('tst', '/tmp/australia_land_of_dragons.png');
INSERT 0  1

JY
--
Any girl who believes that the way to a man's heart is through
his stomach is obviously setting her standards too high.

В списке pgsql-novice по дате отправления:

Предыдущее
От: richard terry
Дата:
Сообщение: Postgres blob question - insert from basic.
Следующее
От: Mike Ellsworth
Дата:
Сообщение: Anonymous code blocks