Re: Trigger output to file.

On Tue, Nov 16, 2004 at 02:32:02AM -0800, Claire McGovern wrote:

> I'm looking for the syntax to get a trigger function
> written in PL/pgSQL to write to a text file.  I want
> to be able to append to the file and not open as new
> each time I write to it.

As far as I know, the only built-in way to write files from PL/pgSQL
is with COPY, which needs a source table and overwrites rather than
appends.  However, you could write a file-appending function in C
or in a procedural language like PL/Perl or PL/Python and call it
from PL/pgSQL.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/