Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group