On Fri, Aug 29, 2008 at 11:12:35PM +0800, Phoenix Kiula wrote: > > How should I check for the locale? As the user that you issue the pg_dump with on the machine you generated it, and as the user you're trying to use to restore the data, at the command line type $ locale You end up with something like this: stovepipe:~ ajs$ locale LANG="en_CA.UTF-8" LC_COLLATE="en_CA.UTF-8" LC_CTYPE="en_CA.UTF-8" LC_MESSAGES="en_CA.UTF-8" LC_MONETARY="en_CA.UTF-8" LC_NUMERIC="en_CA.UTF-8" LC_TIME="en_CA.UTF-8" LC_ALL= I can't remember whether the client encoding is going to be affected by this during dump and restore, and whether in these versions that is captured in the dump file. A -- Andrew Sullivan ajs@xxxxxxxxxxxxxxxxx +1 503 667 4564 x104 http://www.commandprompt.com/
