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

From Melvin Davidson
Subject Re: Possible Values of Command Tag in PG Log file
Date
Msg-id CANu8FiwU+7W93xwaHNg5fHo17XOYcnF0kgQvMRGzmNEVRQCVNQ@mail.gmail.com
Whole thread Raw
In response to RE: Possible Values of Command Tag in PG Log file  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
Responses Re: Possible Values of Command Tag in PG Log file
List pgsql-general

The values and explanations are listed here:

Or simply INSERT, UPDATE, DELETE, SELECT, MOVE, FETCH and/or COPY

On Thu, Jul 18, 2019 at 5:04 PM Kumar, Virendra <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

 authentication

(5 rows)

Regads,
Virendra


-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Thursday, July 18, 2019 4:55 PM
To: Kumar, Virendra; 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

________________________________

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!

pgsql-general by date:

Previous
From: "Kumar, Virendra"
Date:
Subject: RE: Possible Values of Command Tag in PG Log file
Next
From: Adrian Klaver
Date:
Subject: Re: Possible Values of Command Tag in PG Log file