Re: [SQL] Creation of file from postgresql function

2009-06-03 Thread A. Kretschmer
In response to Jyoti Seth : > If anyone has idea about this problem or know any other alternative to > create a file from postgres function, please let me know. > > Thanks, > Jyoti On server-side? You need a function written in an untrusted language, for instance pl/perlU or plsh. Regards, And

[SQL] Creation of file from postgresql function

2009-06-03 Thread Jyoti Seth
Hi, I want to create a file on a disk through postgres function. I am trying to use large objects functions (lo_create, lo_open and lo_write) for this. In this, lo_open command is throwing error "invalid mode" or "Syntax error whereas I have given the value of INV_WRITE from libpq-fs.h as mode.