There is a sample in postgres documentation. (See below).
the only problem is for using langage plpgsql.
If it is not understand by your database, you must use command
createlang plpgsql dbname
as the owner of the database.
CREATE TABLE emp (
empname text,
salary int4,
er work-around might be to lo_export the file
> to a directory writable by nobody.
>
> Regards,
> --
> Guo Bin
>
> --- [EMAIL PROTECTED] wrote:
> > De: Mike Baroukh <[EMAIL PROTECTED]>
> > À: <[EMAIL PROTECTED]>
> > Objet: lo_export and files permiss
De: Mike Baroukh <[EMAIL PROTECTED]>
À: <[EMAIL PROTECTED]>
Objet: lo_export and files permissions
Date : lundi 14 août 2000 10:44
Hi everybody.
Who can help me with a lo_export() problem ? :
I'm using lo_export function in sql statement with pgsql 6.5 on Linux RH 6.2.
Data
