Re: [GENERAL] Writing data to a text file based on a trigger event...

2012-04-16 Thread Vincent Veyron
Le dimanche 15 avril 2012 à 15:43 +0200, Tomas Vondra a écrit : > But if you really need to write the data to a file, you may look at this > contrib module (called "extension" since 9.1) > >http://www.postgresql.org/docs/9.1/interactive/adminpack.html > > You may either use that directly or

Re: [GENERAL] Writing data to a text file based on a trigger event...

2012-04-15 Thread Tomas Vondra
On 12.4.2012 12:58, raghupradeep wrote: > Hi , > > I am basically a MySQL DBA and have little idea on PostgreSQL. In our > environment we have an application which is using PostgreSQL as its back > end. The application logs the status of the jobs running in it to a table in > this database i.e whe

Re: [GENERAL] Writing data to a text file based on a trigger event...

2012-04-14 Thread Jasen Betts
On 2012-04-12, raghupradeep wrote: > Hi , > > I am basically a MySQL DBA and have little idea on PostgreSQL. In our > environment we have an application which is using PostgreSQL as its back > end. The application logs the status of the jobs running in it to a table in > this database i.e when a j

Re: [GENERAL] Writing data to a text file based on a trigger event...

2012-04-12 Thread François Beausoleil
Le jeudi 12 avril 2012 à 06:58, raghupradeep a écrit : > What I need to know is it possible to write a trigger which will write the > data of the row whose status column gets updated to a text file? I would advise simply INSERTing the old values into a new table. This would be more flexible in

[GENERAL] Writing data to a text file based on a trigger event...

2012-04-12 Thread raghupradeep
Hi , I am basically a MySQL DBA and have little idea on PostgreSQL. In our environment we have an application which is using PostgreSQL as its back end. The application logs the status of the jobs running in it to a table in this database i.e when a job starts it inserts a new row to this table an