Logging successful SELECTS?

From: Matthew Vernon <matthew(dot)vernon(at)sac(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging successful SELECTS?
Date: 2013-01-24 12:21:42
Message-ID: 87boceg4b4.fsf@macbeth.sac.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I can get postgres to log unsuccessful queries, including the user who
wrote them, but I'm missing how to get postgres to log the successful
queries too (I don't need a store of the answer, just the query
itself). How do I do this?

Thanks,

Matthew

--
Matthew Vernon
Quantitative Veterinary Epidemiologist
Epidemiology Research Unit, SAC Inverness

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moshe Jacobson 2013-01-24 12:47:49 Re: Optimizing select count query which often takes over 10 seconds
Previous Message Craig Ringer 2013-01-24 12:11:16 Re: BUG #6510: A simple prompt is displayed using wrong charset