Thread: Need values for encoding table

"Leo" <fleovey@jus.gov.ar> writes:
> I am picking up the encoding for my databases from TABLE pg_database in template1, from the field "encoding"

> For SQL_ASCII I get  a 0
> For UTF-8  I get a 6
> Can somebody supply all the encoding values? I cannot locate them

I think you're looking for the pg_encoding_to_char() function.
It's not terribly well documented perhaps :-( ... I'd be interested to
know what parts of the docs you looked in.

            regards, tom lane