Re: Possible Values of Command Tag in PG Log file

On 7/18/19 2:13 PM, Melvin Davidson wrote:
>
> The values and explanations are listed here:
> https://www.postgresql.org/docs/11/protocol-message-formats.html
>
> Or simply INSERT, UPDATE, DELETE, SELECT, MOVE, FETCH and/or COPY

Except the OP shows a command that is not in the above, authentication.

Also this:

https://www.postgresql.org/docs/11/event-trigger-interface.html

The command tag associated with the event for which the event trigger is
run, for example "CREATE FUNCTION".

I suspect it comes from the commands listed here:

/src/include/commands
/src/backend/commands

How to pull out the complete list is beyond me at the moment.

>
> On Thu, Jul 18, 2019 at 5:04 PM Kumar, Virendra
> <Virendra(dot)Kumar(at)guycarp(dot)com <mailto:Virendra(dot)Kumar(at)guycarp(dot)com>> wrote:
>
> Here is it:
> --
> https://www.postgresql.org/docs/10/protocol-message-formats.html
>
> CommandComplete (B), string value of this section.
>
> I loaded log file (csv format) into postgres_log table as per below
> document and can see entries like:
> https://www.postgresql.org/docs/10/runtime-config-logging.html
>
> postgres=# select command_tag from postgres_log where command_tag is
> not null limit 5;
>   command_tag
> ----------------
>
>
>
>  authentication
>
> (5 rows)
>
> Regads,
> Virendra
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>]
> Sent: Thursday, July 18, 2019 4:55 PM
> To: Kumar, Virendra; pgsql-general(at)lists(dot)postgresql(dot)org
> <mailto:pgsql-general(at)lists(dot)postgresql(dot)org>
> Subject: Re: Possible Values of Command Tag in PG Log file
>
> On 7/18/19 12:58 PM, Kumar, Virendra wrote:
> > Hello Team,
> >
> > Can somebody redirect me to document which lists all possible
> value of
> > command tag in instance log of PostgreSQL instance.
>
> Can you show example of a command tag in the log?
>
> >
> > Regards,
> >
> > Virendra
> >
> >
> >
> ------------------------------------------------------------------------
> >
> > This message is intended only for the use of the addressee and
> may contain
> > information that is PRIVILEGED AND CONFIDENTIAL.
> >
> > If you are not the intended recipient, you are hereby notified
> that any
> > dissemination of this communication is strictly prohibited. If
> you have
> > received this communication in error, please erase all copies of
> the message
> > and its attachments and notify the sender immediately. Thank you.
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
> ________________________________
>
> This message is intended only for the use of the addressee and may
> contain
> information that is PRIVILEGED AND CONFIDENTIAL.
>
> If you are not the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please erase all copies of the
> message
> and its attachments and notify the sender immediately. Thank you.
>
>
>
>
> --
> *Melvin Davidson**
> Maj. Database & Exploration Specialist**
> Universe Exploration Command – UXC***
> Employment by invitation only!

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com