Re: Need values for encoding table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Leo" <fleovey(at)jus(dot)gov(dot)ar>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Need values for encoding table
Date: 2008-05-17 02:56:14
Message-ID: 18534.1210992974@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Leo" <fleovey(at)jus(dot)gov(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas 2008-05-17 23:36:20 How let client store stuff encypted ?
Previous Message Leo 2008-05-16 19:17:49 Need values for encoding table