X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 718369DCA7E for ; Mon, 27 Mar 2006 07:24:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32839-10 for ; Mon, 27 Mar 2006 07:24:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 2B36B9DC99E for ; Mon, 27 Mar 2006 07:24:24 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k2RBFGJ9014680; Mon, 27 Mar 2006 16:45:16 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 3BB8C33266A; Mon, 27 Mar 2006 16:45:16 +0530 (IST) Message-ID: <019701c65191$6edfb420$cd00000a@sandhyar> From: "sandhya" To: "Jim C. Nasby" Cc: "Michael Fuhr" , "Postgres" References: <00e501c65169$815dc560$cd00000a@sandhyar> <20060327064536.GA21988@winnie.fuhr.org> <015001c65181$876df840$cd00000a@sandhyar> <20060327103825.GR80726@pervasive.com> Subject: Re: reg:create database Date: Mon, 27 Mar 2006 16:57:29 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:19 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.133 required=5 tests=[AWL=0.132, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.133 X-Spam-Level: X-Archive-Number: 200603/291 X-Sequence-Number: 21048 oh.....ok Now, just because you can do this doesn't mean it's a very good idea... Why? ----- Original Message ----- From: "Jim C. Nasby" To: "sandhya" Cc: "Michael Fuhr" ; "Postgres" Sent: Monday, March 27, 2006 4:08 PM Subject: Re: [ADMIN] reg:create database > On Mon, Mar 27, 2006 at 03:03:38PM +0530, sandhya wrote: > > Dear Michale.. > > I am unable to get answer from the link you sent...Just tell me whether > > it is possible or not. > > In the document they mentioned that . is used as a seperator for a > > table/column name...So Is it any way to use dot while creating a > > table/database > > decibel=# create database "dot.test"; > CREATE DATABASE > decibel=# \c "dot.test" > You are now connected to database "dot.test". > dot.test=# > > Now, just because you can do this doesn't mean it's a very good idea... > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >