Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMJMh-0007VE-C2 for pgsql-sql@postgresql.org; Thu, 11 Oct 2012 14:03:55 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMJMe-0001a8-8T for pgsql-sql@postgresql.org; Thu, 11 Oct 2012 14:03:54 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q9BE3mrt029821; Thu, 11 Oct 2012 10:03:49 -0400 (EDT) From: Tom Lane To: Sebastien FLAESCH cc: pgsql-sql@postgresql.org Subject: Re: Database object names and libpq in UTF-8 locale on Windows In-reply-to: <507689D4.3050804@4js.com> References: <507689D4.3050804@4js.com> Comments: In-reply-to Sebastien FLAESCH message dated "Thu, 11 Oct 2012 10:56:52 +0200" Date: Thu, 11 Oct 2012 10:03:48 -0400 Message-ID: <29820.1349964228@sss.pgh.pa.us> X-Pg-Spam-Score: -4.0 (----) X-Archive-Number: 201210/33 X-Sequence-Number: 36904 Sebastien FLAESCH writes: > - I can use UTF-8 string constants in my queries. > - I can pass UTF-8 data to the database with parameterized queries. > - I can fetch UTF-8 data from the database. > - I can create db object names with UTF-8 characters. > But the db object names must be specified with double quotes: > When I do not use quoted db object names, I get a strange problem. > The table is created, I can use it in my program, I can even use it in the > pgAdmin query tool, but in the pgAdmin db browser, there is no table name > displayed in the treeview... That sounds like a pgAdmin bug. You should report it in the pgAdmin mailing lists. regards, tom lane