Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0907C2E345D for ; Tue, 8 Jan 2008 17:58:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 90146-09 for ; Tue, 8 Jan 2008 17:58:49 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B7E4B2E346A for ; Tue, 8 Jan 2008 17:58:49 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m08Lwk34014710; Tue, 8 Jan 2008 16:58:46 -0500 (EST) To: Steve Crawford cc: Chris Hoover , "pgsql-admin@postgresql.org Admin" Subject: Re: All numeric database names? In-reply-to: <4783E41F.6040608@pinpointresearch.com> References: <1d219a6f0801081103m183c00a2k38c3e01b99b7b48b@mail.gmail.com> <4783E41F.6040608@pinpointresearch.com> Comments: In-reply-to Steve Crawford message dated "Tue, 08 Jan 2008 12:59:11 -0800" Date: Tue, 08 Jan 2008 16:58:46 -0500 Message-ID: <14709.1199829526@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/91 X-Sequence-Number: 27865 Steve Crawford writes: > Alternately, you could prepend 1+ alpha characters to the customer > numbers to create names like c123456 or cust123456 which don't need to > be quote-enclosed. I'd recommend that too. Quite aside from the quoting problem, this will save you tons of confusion if you ever have to deal with database OIDs (during disaster recovery perhaps). regards, tom lane