[GENERAL] Getting a list of encodings.

2009-05-11 Thread Andrew Maclean
Is it possible to query the database system tables and get a list of available database encodings? i.e UTF8, LATIN2, SQL_ASCII ... etc. I don't know what view or table to use. Thanks for any help Andrew -- ___ Andrew J. P. Maclean Centre for Autonomous

Re: [GENERAL] Getting a list of encodings.

2009-05-11 Thread Tom Lane
Andrew Maclean 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 -- Sent vi

Re: [GENERAL] Getting a list of encodings.

2009-05-11 Thread Andrew Maclean
Thankyou very much. On Tue, May 12, 2009 at 9:37 AM, Tom Lane wrote: > Andrew Maclean 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