From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Ivan Voras" <ivoras(at)freebsd(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Simple row serialization? |
Date: | 2008-01-26 17:49:26 |
Message-ID: | 162867790801260949k48609f5an8e187867f7106440@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
use plperl.
PostgreSQL hasn't simple tool for it. Maybe this link will be usefull for you
http://www.ciselant.de/projects/pg_ci_diff/
Pavel
On 26/01/2008, Ivan Voras <ivoras(at)freebsd(dot)org> wrote:
> Hi,
>
> I'd like to implement some simple data logging via triggers on a small
> number of infrequently updated tables and I'm wondering if there are
> some helpful functions, plugins or idioms that would serialize a row
> (received for example in a AFTER INSERT trigger) into a string that I'd
> store in the log table. There's a limited number of field types
> involved: varchars, integers and booleans. I'm not looking for anything
> fancy, comma-separated string result will be just fine; Even better,
> something like a dictionary ("field_name":"field_value",...) would be
> nice. The reason for trying to do it this way is that I don't want to
> create separate log tables for every table I wish to log.
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2008-01-26 18:01:09 | Re: Simple row serialization? |
Previous Message | Robert Treat | 2008-01-26 17:07:25 | Re: plperl: Documentation on BYTEA decoding is wrong |