Re: Possible Values of Command Tag in PG Log file - Mailing list pgsql-general

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.Kumar@guycarp.com <mailto:Virendra.Kumar@guycarp.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.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.com>]
>     Sent: Thursday, July 18, 2019 4:55 PM
>     To: Kumar, Virendra; pgsql-general@lists.postgresql.org
>     <mailto:pgsql-general@lists.postgresql.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com