Re: pg_enconding

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dextra - Gustavo Bartz Guedes <gustavo-bartz(at)dextra(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_enconding
Date: 2005-04-18 17:34:42
Message-ID: 23951.1113845682@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dextra - Gustavo Bartz Guedes <gustavo-bartz(at)dextra(dot)com(dot)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

In response to

  • pg_enconding at 2005-04-18 16:34:37 from Dextra - Gustavo Bartz Guedes

Browse pgsql-admin by date

  From Date Subject
Next Message Garris, Nicole 2005-04-18 18:14:26 Admin Tool to Send Me Email
Previous Message Gustavo Franklin Nóbrega - Planae 2005-04-18 17:24:40 RES: pg_enconding