Re: Cast record as text

From: Mikko Partio <dun(at)haisuli(dot)net>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cast record as text
Date: 2007-02-17 12:39:15
Message-ID: 45D6F773.5070502@haisuli.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A. Kretschmer wrote:
>> My original idea was to log changes from different tables to one audit
>> table, and I think tablelog uses separate audit tables for each monitored
>> table?
>>
>
> Yes, but with tablelog it is possible to restore any changes, you can
> restore a table.
>
> A blog-entry from Andreas Scherbaum, the maintainer, about tablelog:
> http://ads.wars-nicht.de/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html
>

I agree that the ability to restore changes is quite nice, but my
primary goal is to record changes from many tables into one table, and I
think tablelog does not offer that. Do you know any way of casting a
record to text, or perhaps a different way altogether to audit to one
table? It's hard to believe I am the first person to come up to this
problem.

Regards

MP

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leonel Nunez 2007-02-17 12:58:17 Re: postgreSQL
Previous Message Bob Hunter 2007-02-17 11:12:44 encoding problem at restore