How to export query results

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: How to export query results
Date: 2007-08-21 14:54:50
Message-ID: 1d219a6f0708210754v456fecaer68d0420cf2526c12@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Thanks,

Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2007-08-21 14:57:39 Re: Dump & Load a database???
Previous Message smiley2211 2007-08-21 14:50:01 Dump & Load a database???