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 556079DCC99 for ; Mon, 27 Mar 2006 07:43:24 -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 38252-04 for ; Mon, 27 Mar 2006 07:43:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 0051C9DCCB2 for ; Mon, 27 Mar 2006 07:43:21 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 2F0BE56431; Mon, 27 Mar 2006 05:43:10 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Mon, 27 Mar 2006 05:43:09 -0600 Date: Mon, 27 Mar 2006 05:43:09 -0600 From: "Jim C. Nasby" To: sandhya Cc: Michael Fuhr , Postgres Subject: Re: reg:create database Message-ID: <20060327114309.GV80726@pervasive.com> References: <00e501c65169$815dc560$cd00000a@sandhyar> <20060327064536.GA21988@winnie.fuhr.org> <015001c65181$876df840$cd00000a@sandhyar> <20060327103825.GR80726@pervasive.com> <019701c65191$6edfb420$cd00000a@sandhyar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <019701c65191$6edfb420$cd00000a@sandhyar> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060327:sandhyar@amiindia.co.in::QDwPt/vd/1Us1VhZ:00000000000000 0000000000000000000000001u6q X-Hashcash: 1:20:060327:mike@fuhr.org::229Ue8/hyNtJLZxf:00000Pyp X-Hashcash: 1:20:060327:pgsql-admin@postgresql.org::WU9RfRyurPq315Qx:00000000000 00000000000000000000000024af X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/293 X-Sequence-Number: 21050 On Mon, Mar 27, 2006 at 04:57:29PM +0530, sandhya wrote: > > > 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... > oh.....ok > Now, just because you can do this doesn't mean it's a very good idea... > Why? Because it's likely to lead to confusion, since SQL uses dots as seperators between databases, schemas, and objects; ie: databasename.schemaname.tablename.columname. Granted, PostgreSQL doesn't (currently) allow you to do per-database specifications, but that could change. In any case, it's asking for trouble. -- 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