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
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
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
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
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