Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2007-08-21 14:57:39
Subject: Re: Dump & Load a database???
Previous:From: smiley2211Date: 2007-08-21 14:50:01
Subject: Dump & Load a database???

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group