Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting a list of encodings. - Mailing list pgsql-general

From Tom Lane
Subject Re: Getting a list of encodings.
Date
Msg-id 2855.1242085026@sss.pgh.pa.us
Whole thread Raw
In response to Getting a list of encodings.  (Andrew Maclean <andrew.amaclean@gmail.com>)
Responses Re: Getting a list of encodings.  (Andrew Maclean <andrew.amaclean@gmail.com>)
List pgsql-general
Tree view 
Andrew Maclean <andrew.amaclean@gmail.com> writes:
> Is it possible to query the database system tables and get a list of
> available database encodings?

The pg_encoding_to_char() function might help you, eg

select pg_encoding_to_char(i) from generate_series(0,100) i;

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Maclean
Date:
Subject: Getting a list of encodings.
Next
From: "Vikram Patil"
Date:
Subject: Compiler versions on different platforms