How to log full substituted queries?
От | andrew fabbro |
---|---|
Тема | How to log full substituted queries? |
Дата | |
Msg-id | Pine.LNX.4.64.0601182037020.15506@hallofjustice.fabbro.org обсуждение исходный текст |
Ответы |
Re: How to log full substituted queries?
|
Список | pgsql-general |
I'm trying to debug some queries and have log_statement = 'all' in my postgresql.conf. When I look in the resultant log file, I see entries like this: INSERT INTO servers ( hostname, last_modified, serial, asset_tag, grid, admin ) VALUES ( $1,CURRENT_DATE,$2, $3,$4,$5 ) What I'd actually like to see is the fully-parsed version, e.g. INSERT INTO servers ( hostname, last_modified, serial, asset_tag, grid, admin ) VALUES ( 'loki', CURRENT_DATE, '10-129CF', '213457','23G','ut1' ) ...so I can see what the client is actually sending. Is there a way to do this? andrew fabbro [andrew@fabbro.org] ------------------------------[ quote-o-matic] ----------------------------- "I didn't say that." -- Oliver Wendell Holmes
В списке pgsql-general по дате отправления: