On 8/21/07, Chris Hoover <revoohc@gmail.com> 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 am
> drawing a blank on how to export the results of the query.
Yes. you need to use the copy command inside a function and use
security definer to say that the function runs as a superuser.