Thread: application_name

Hello to everyone,
I would have a stange question: many times I found the variable
application_name in various context, but I never understood the meaning.

What is the standard use of this variable? How can I use it?

Thanks in advance.

Meph

--
View this message in context: http://postgresql.1045698.n5.nabble.com/application-name-tp5521092p5521092.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

On 02/28/2012 02:38 AM, mephysto wrote:

Hello to everyone,
I would have a stange question: many times I found the variable
application_name in various context, but I never understood the meaning.

What is the standard use of this variable? How can I use it?

Thanks in advance.

Meph

--
View this message in context: http://postgresql.1045698.n5.nabble.com/application-name-tp5521092p5521092.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

From postgresql.org:

application_name (string)

The application_name can be any string of less than NAMEDATALEN characters (64 characters in a standard build). It is typically set by an application upon connection to the server. The name will be displayed in the pg_stat_activity view and included in CSV log entries. It can also be included in regular log entries via the log_line_prefix parameter. Only printable ASCII characters may be used in the application_name value. Other characters will be replaced with question marks (?).

Google can be your friend!

Thank you very much.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/application-name-tp5521092p5600495.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.