Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has)

On Wed, 22 Feb 2023 at 13:38, Kirk Wolak <wolakk(at)gmail(dot)com> wrote:
>
> I already requested ONLY the HH24 format. 8 characters of output. no options. It's a waste of time.
> After all these years, sqlplus still has only one setting (show it, or not). I am asking the same here.
> And I will gladly defend not changing it! Ever!

Yeah, well, it's kind of beside the point that you're satisfied with
this one format. We tend to think about what all users would expect
and what a complete feature would look like.

I actually tend to think this would be a nice feature. It's telling
that log files and other tracing tools tend to produce exactly this
type of output with every line prefixed with either a relative or
absolute timestamp.

I'm not sure if the *prompt* is a sensible place for it though. The
place it seems like it would be most useful is reading the output of
script executions where there would be no prompts. Perhaps it's the
command tags and \echo statements that should be timestamped.

And I think experience shows that there are three reasonable formats
for dates, the default LC_TIME format, ISO8601, and a relative
"seconds (with milliseconds) since starting". I think having a feature
that doesn't support those three would feel incomplete and eventually
need to be finished.

--
greg