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 по дате отправления: