Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_enconding - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_enconding
Date
Msg-id 23951.1113845682@sss.pgh.pa.us
Whole thread Raw
In response to pg_enconding  (Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>)
List pgsql-admin
Tree view 
Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br> writes:
> The version 8.0 has not the pg_encoding tool, so how can I find a
> encoding by its number on pg_database.enconding?

See pg_char_to_encoding() and pg_encoding_to_char().  For instance

select datname,pg_encoding_to_char(encoding) from pg_database;

            regards, tom lane

pgsql-admin by date:

Previous
From: Gustavo Franklin Nóbrega - Planae
Date:
Subject: RES: pg_enconding
Next
From: "Garris, Nicole"
Date:
Subject: Admin Tool to Send Me Email