Hrishikesh Deshmukh wrote:
> Hi All,
>
> I want to get a "timestamp" of the queries that i run!
> Is there a builtin command to do this/ does one need to write a
> function/stored procedure!
> Any pointers will help.
You don't say where you want this "timestamp".
In psql look into "\timing" (see the man page)
To record this in the logs, see the configuration section of the manual,
specifically "Error Reporting and Logging"
--
Richard Huxton
Archonet Ltd