On 8/21/07, Chris Hoover <[EMAIL PROTECTED]> wrote:
> On 8/21/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> >
> > Yes. you need to use the copy command inside a function and use
> > security definer to say that the function runs as a superuser.
> >
>
>
> Ok, I thought from the documentation that
On 8/21/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
>
> Yes. you need to use the copy command inside a function and use
> security definer to say that the function runs as a superuser.
>
Ok, I thought from the documentation that copy could only extract entire
table or a specific column.
If I
On 8/21/07, Chris Hoover <[EMAIL PROTECTED]> wrote:
> I need some guidance.
>
> I need to have an after insert trigger execute on a specific table and
> export the results of query to a file on the database file system. Is this
> possible to do from a trigger? If so, how can I accomplish this? I
I need some guidance.
I need to have an after insert trigger execute on a specific table and
export the results of query to a file on the database file system. Is this
possible to do from a trigger? If so, how can I accomplish this? I am
drawing a blank on how to export the results of the query
