use of client-side \lo_import and \lo_export commands

Поиск
Список
Период
Сортировка
От Viacheslav Kovalchuk
Тема use of client-side \lo_import and \lo_export commands
Дата
Msg-id F52OeIiGXix4A2DreBB0001cef4@hotmail.com
обсуждение исходный текст
Список pgsql-sql
I am trying to insert a large object into my dbs
using: INSERT INTO table VALUES (lo_import ( ' z/image/image.jpg ' ));

but i get the message saying that I need superuser privilidges to do it and 
that I should use client-side
\lo_import command.

Does anyone know how to use that command? And what is the syntax for 
\lo_import and export commands?

Many thanks in advance.
Slava




Viacheslav Kovalchuk
--------------------
slavic1@hotmail.com



_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com



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

Предыдущее
От: "Christian Lübeck"
Дата:
Сообщение: Function using more than one database
Следующее
От: Robert Treat
Дата:
Сообщение: Re: how do I change regional setting for dates?