Trigger output to file.

From: Claire McGovern <bramble_za(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Trigger output to file.
Date: 2004-11-16 10:32:02
Message-ID: 20041116103202.83511.qmail@web50902.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Two things...
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.
Secondly, I'm using pgadmin III to run queries against
my database, I've tried to use the \o option to output
to a file and get an objection about the \o... Any
ideas as to output to a file from this query tool?

Claire


__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Roberto Fichera 2004-11-16 14:40:14 pg_dump errors
Previous Message sarlav kumar 2004-11-15 14:47:33 upgrade from postgres 7.3.2