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