Re: [GENERAL] non superuser creating flat files

2007-08-17 Thread Terri Reid
Tom, Thank you very much, that works now. Terri Reid 01925 732359 -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 13 August 2007 15:50 To: Terri Reid Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] non superuser creating flat files "Terri Reid&quo

Re: [GENERAL] non superuser creating flat files

2007-08-13 Thread Scott Marlowe
On 8/13/07, Erik Jones <[EMAIL PROTECTED]> wrote: > > On Aug 13, 2007, at 9:50 AM, Tom Lane wrote: > > > "Terri Reid" <[EMAIL PROTECTED]> 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 > >

Re: [GENERAL] non superuser creating flat files

2007-08-13 Thread Erik Jones
On Aug 13, 2007, at 9:50 AM, Tom Lane wrote: "Terri Reid" <[EMAIL PROTECTED]> 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

Re: [GENERAL] non superuser creating flat files

2007-08-13 Thread Tom Lane
"Terri Reid" <[EMAIL PROTECTED]> 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.