Tom, Thank you very much, that works now. Terri Reid 01925 732359 -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: 13 August 2007 15:50 To: Terri Reid Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: non superuser creating flat files "Terri Reid" <treid@xxxxxxxxxxxxxxxxxxx> writes: > I have data that is being updated in a table that I need to export to a flat > file via a database trigger on insert or update. The user performing the > update will not be a superuser. I've tried to use COPY TO, but that doesn't > work for non-superusers. It will if invoked in a trigger function that's marked SECURITY DEFINER and owned by a superuser. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
