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

Re: Automatic export

From: "Daniel T(dot) Staal" <DStaal(at)usa(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Automatic export
Date: 2006-07-26 19:27:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Wed, July 26, 2006 3:17 pm, Keith Worthington said:
> Hi All,
> I need to export several records of a single colum from a table in a
> database everytime that table is updated.  The data needs to end up in a
> text file. Can someone give me an idea on where to get started?  URL's to
> relevant documentation would be appreciated.  TIA

I'd start here:

Write a trigger on insert/update on that table, and have it export the

Daniel T. Staal

This email copyright the author.  Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes.  This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.

In response to


pgsql-novice by date

Next:From: Michael FuhrDate: 2006-07-26 23:38:07
Subject: Re: Automatic export
Previous:From: Keith WorthingtonDate: 2006-07-26 19:17:56
Subject: Automatic export

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