Re: How to log whole query statement to relation?

Поиск
Список
Период
Сортировка
От David Flegl
Тема Re: How to log whole query statement to relation?
Дата
Msg-id 462DE66E.4010401@centrum.cz
обсуждение исходный текст
Ответ на Re: How to log whole query statement to relation?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: How to log whole query statement to relation?
Список pgsql-novice
Hi,
 > I think, you can't do log the sql as text, but you can tools like
 > 'tablelog' to obtain a similar behavior:

thank's for inspiration.

And another question. Is it possible to parse record type NEW? How could
one do something like (in trigger where new is set up):
  text_var:=to_char(NEW)
So if NEW.at1='test' and NEW.at2=100 I will get string: 'test',100
But the problem is then if trigger is generally used for many tables, I
don't know number of elements and so on.

I know that for basic types is defined out function, and I may get this
  behavior for example point type this way:
SELECT textin(point_out('(1,1)'::point))::varchar;

Thank's to help me...

David F




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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How to log whole query statement to relation?
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How to log whole query statement to relation?