Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= <l.rame@xxxxxxxxxxx> writes: > Hi, we found characters with different enconding in our database. As our > system is accessed by many PCs I would like to know if it's possible to > know the encoding of each connection, without going to each PC to check > its connection string. If you mean can one session identify the client_encoding of another session, no; that information isn't exposed anyplace. Within a session, you can of course use "show client_encoding" or various equivalent syntaxes. Note that when you have encoding problems, as often as not the issue is that the data the client is sending isn't really in the encoding its client_encoding setting claims. So even if you could find that out remotely, it probably wouldn't help localize the issue very well. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
