Simple row serialization?

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Simple row serialization?
Дата
Msg-id fnfojr$ms7$1@ger.gmane.org
обсуждение исходный текст
Ответы Re: Simple row serialization?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Simple row serialization?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: plperl: Documentation on BYTEA decoding is wrong
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Simple row serialization?