From sandhyar@amiindia.co.in Mon Mar 27 06:35:54 2006 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 BE1C89DC89A for ; Mon, 27 Mar 2006 02:35:54 -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 80389-08 for ; Mon, 27 Mar 2006 02:35:54 -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 AD1389DC85D for ; Mon, 27 Mar 2006 02:35:45 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k2R6TaT3020252 for ; Mon, 27 Mar 2006 11:59:36 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 9772A33266A; Mon, 27 Mar 2006 11:59:27 +0530 (IST) Message-ID: <00e501c65169$815dc560$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: reg:create database Date: Mon, 27 Mar 2006 12:11:40 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00E2_01C65197.9B02EE90" 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:64.70593 C:22 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.134 required=5 tests=[AWL=0.132, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.134 X-Spam-Level: X-Archive-Number: 200603/282 X-Sequence-Number: 21039 This is a multi-part message in MIME format. ------=_NextPart_000_00E2_01C65197.9B02EE90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi... I want to have a database/table with dot( . ) in its name.But i am = unable to create a database with a dot in the middle of its name..Is = there any possibility of doing it?If yes pls tell me. Thank you, Sandhya ------=_NextPart_000_00E2_01C65197.9B02EE90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi...
 
   I want to have a database/table with = dot(=20 . ) in its name.But i am unable to create a database = with a dot=20 in the middle of its name..Is there any possibility of doing it?If yes = pls tell=20 me.
 
Thank you,
Sandhya
------=_NextPart_000_00E2_01C65197.9B02EE90-- From mike@fuhr.org Mon Mar 27 06:45:49 2006 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 C34D09DC99D for ; Mon, 27 Mar 2006 02:45:49 -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 81544-07 for ; Mon, 27 Mar 2006 02:45:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 2F0559DC959 for ; Mon, 27 Mar 2006 02:45:46 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k2R6jbic013726 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sun, 26 Mar 2006 23:45:40 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k2R6ja1D022066; Sun, 26 Mar 2006 23:45:36 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k2R6jaVh022065; Sun, 26 Mar 2006 23:45:36 -0700 (MST) (envelope-from mfuhr) Date: Sun, 26 Mar 2006 23:45:36 -0700 From: Michael Fuhr To: sandhya Cc: Postgres Subject: Re: reg:create database Message-ID: <20060327064536.GA21988@winnie.fuhr.org> References: <00e501c65169$815dc560$cd00000a@sandhyar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00e501c65169$815dc560$cd00000a@sandhyar> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.121 required=5 tests=[AWL=0.121] X-Spam-Score: 0.121 X-Spam-Level: X-Archive-Number: 200603/283 X-Sequence-Number: 21040 On Mon, Mar 27, 2006 at 12:11:40PM +0530, sandhya wrote: > I want to have a database/table with dot( . ) in its name.But > i am unable to create a database with a dot in the middle of its > name..Is there any possibility of doing it?If yes pls tell me. See the documentation regarding quoted identifiers. http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS -- Michael Fuhr From andy.shellam@mailnetwork.co.uk Mon Mar 27 09:32:51 2006 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 811D99DC8A7 for ; Mon, 27 Mar 2006 05:32:51 -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 12050-09 for ; Mon, 27 Mar 2006 05:32:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 1ED9C9DC892 for ; Mon, 27 Mar 2006 05:32:49 -0400 (AST) Received: from [213.146.143.243] (port=61185 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FNo5e-0006rh-2Q; Mon, 27 Mar 2006 10:32:46 +0100 Reply-To: From: "Andy Shellam" To: "'sandhya'" Cc: Subject: Re: reg:create database Date: Mon, 27 Mar 2006 10:32:44 +0100 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <015001c65181$876df840$cd00000a@sandhyar> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcZRgMY67oDF12vrTY27x9tt+Ng+NgAAINVg X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.178 required=5 tests=[AWL=0.178] X-Spam-Score: 0.178 X-Spam-Level: X-Archive-Number: 200603/287 X-Sequence-Number: 21044 > In the document they mentioned that . is used as a seperator for a > table/column name I would say for this very reason the answer would be No, but I might be wrong... Andy From sandhyar@amiindia.co.in Mon Mar 27 09:27:25 2006 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 586289DC863 for ; Mon, 27 Mar 2006 05:27:25 -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 12899-03 for ; Mon, 27 Mar 2006 05:27:26 -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 927109DCC4A for ; Mon, 27 Mar 2006 05:27:20 -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 k2R9LPs0023456; Mon, 27 Mar 2006 14:51:25 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 0293E33266D; Mon, 27 Mar 2006 14:51:25 +0530 (IST) Message-ID: <015001c65181$876df840$cd00000a@sandhyar> From: "sandhya" To: "Michael Fuhr" Cc: "Postgres" References: <00e501c65169$815dc560$cd00000a@sandhyar> <20060327064536.GA21988@winnie.fuhr.org> Subject: Re: reg:create database Date: Mon, 27 Mar 2006 15:03:38 +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/286 X-Sequence-Number: 21043 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 ----- Original Message ----- From: "Michael Fuhr" To: "sandhya" Cc: "Postgres" Sent: Monday, March 27, 2006 12:15 PM Subject: Re: [ADMIN] reg:create database > On Mon, Mar 27, 2006 at 12:11:40PM +0530, sandhya wrote: > > I want to have a database/table with dot( . ) in its name.But > > i am unable to create a database with a dot in the middle of its > > name..Is there any possibility of doing it?If yes pls tell me. > > See the documentation regarding quoted identifiers. > > http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > From skn@gsecone.com Mon Mar 27 09:39:23 2006 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 8D32E9DC9C4 for ; Mon, 27 Mar 2006 05:39:23 -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 13129-05 for ; Mon, 27 Mar 2006 05:39:24 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3E2BC9DC9A8 for ; Mon, 27 Mar 2006 05:39:21 -0400 (AST) Received: from gsecone.com (gsecone.com [59.144.0.4]) by svr4.postgresql.org (Postfix) with ESMTP id D62C05AF042 for ; Mon, 27 Mar 2006 09:39:22 +0000 (GMT) Received: from [127.0.0.1] ([192.168.2.1]) by gsecone.com (8.12.8/8.12.8) with ESMTP id k2R999vE011558; Mon, 27 Mar 2006 14:39:10 +0530 Message-ID: <4427B2B4.9010405@gsecone.com> Date: Mon, 27 Mar 2006 15:09:00 +0530 From: "Kannan.S" User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: andy.shellam@mailnetwork.co.uk Cc: "'sandhya'" , pgsql-admin@postgresql.org Subject: Re: reg:create database References: In-Reply-To: Content-Type: multipart/mixed; boundary="------------060308060609050709010805" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/288 X-Sequence-Number: 21045 This is a multi-part message in MIME format. --------------060308060609050709010805 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Sandhya, Hope this will explain, why it is so ... http://www.postgresql.org/docs/7.4/static/ddl-schemas.html Kannan Andy Shellam wrote: >> In the document they mentioned that . is used as a seperator for a >> table/column name >> > > I would say for this very reason the answer would be No, but I might be > wrong... > > Andy > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > > -- GSEC1 (A Division of ITAC UK Limited) Chennai, India | Manchester, UK Tel : +91 44 4202 2601 - 2605 Fax : +91 44 4202 2606 Mobile : +91 988411 4931 URL : www.gsec1.com ****** This email is confidential and is intended for the original recipient(s) only. If you have erroneously received this mail, please delete it immediately and notify the sender. Unauthorised copying, disclosure or distribution of the material in this mail is prohibited. Views expressed in this mail are those of the individual sender and do not bind GSec1 (A Division of ITAC UK Limited) or its subsidiary, unless the sender has done so expressly with due authority of GSec1 (A Division of ITAC UK Limited).****** --------------060308060609050709010805 Content-Type: text/x-vcard; charset=utf-8; name="skn.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="skn.vcf" begin:vcard fn:Kannan.S n:;Kannan.S org:GSEC1;R&D adr:G N Chetty Road, T. Nagar;;Level 2, 88 Anmol Palani;Chennai;Tamil Nadu;600017;India email;internet:skn@gsecone.com title:Senior Member Technical tel;work:+91 44 4202 2601 tel;fax:+91 44 4202 2606 tel;home:+91 44 4202 2701 tel;cell:+91 988411 4931 note:*** This email is confidential and is intended for the original recipient(s) only. If you have erroneously received this mail, please delete it immediately and notify the sender. Unauthorised copying, disclosure or distribution of the material in this mail is prohibited. Views expressed in this mail are those of the individual sender and do not bind GSEC1 (A Division of ITAC UK Limited) or its subsidiary, unless the sender has done so expressly with due authority of GSEC1 (A Division of ITAC UK Limited). *** x-mozilla-html:TRUE url:http://www.gsec1.com version:2.1 end:vcard --------------060308060609050709010805-- From jnasby@pervasive.com Mon Mar 27 10:38:25 2006 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 D20719DCB10 for ; Mon, 27 Mar 2006 06:38:25 -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 25133-03 for ; Mon, 27 Mar 2006 06:38:27 -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 CBA869DCA05 for ; Mon, 27 Mar 2006 06:38:23 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 92CC456431; Mon, 27 Mar 2006 04:38:26 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Mon, 27 Mar 2006 04:38:25 -0600 Date: Mon, 27 Mar 2006 04:38:25 -0600 From: "Jim C. Nasby" To: sandhya Cc: Michael Fuhr , Postgres Subject: Re: reg:create database Message-ID: <20060327103825.GR80726@pervasive.com> References: <00e501c65169$815dc560$cd00000a@sandhyar> <20060327064536.GA21988@winnie.fuhr.org> <015001c65181$876df840$cd00000a@sandhyar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <015001c65181$876df840$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::KWH5K47NJtHuzh0V:00000000000000 0000000000000000000000001E8b X-Hashcash: 1:20:060327:mike@fuhr.org::8He1mSZ4y8E3M9UY:00004fAM X-Hashcash: 1:20:060327:pgsql-admin@postgresql.org::Nx84SlJngxDkxdW2:00000000000 0000000000000000000000007kgj 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/290 X-Sequence-Number: 21047 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 From sandhyar@amiindia.co.in Mon Mar 27 11:24:28 2006 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 > From andy.shellam@mailnetwork.co.uk Mon Mar 27 11:36:19 2006 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 D1CD09DC99E for ; Mon, 27 Mar 2006 07:36:19 -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 37275-03 for ; Mon, 27 Mar 2006 07:36:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id ACDB39DC800 for ; Mon, 27 Mar 2006 07:36:17 -0400 (AST) Received: from [213.146.143.243] (port=43639 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FNq1A-00070N-VN; Mon, 27 Mar 2006 12:36:17 +0100 Reply-To: From: "Andy Shellam" To: "'sandhya'" Cc: Subject: Re: reg:create database Date: Mon, 27 Mar 2006 12:36:16 +0100 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <019701c65191$6edfb420$cd00000a@sandhyar> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcZRkTPu9xtP/KvMQweG2X75esIqBwAAJp+Q X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.175 required=5 tests=[AWL=0.175] X-Spam-Score: 0.175 X-Spam-Level: X-Archive-Number: 200603/292 X-Sequence-Number: 21049 You can throw your computer out of a 10-story window - but just because you can do it doesn't mean it's a good idea. It's just wrong. In your particular case it depends on whichever library/ interface/ application you're using to communicate with PG (e.g. PGSQL manager, the dump and restore tools, PHP's library, libpq.dll etc) - as they will all have to realise that there is a dot in the table/column name, and will have to quote it, or PG will complain. And you'll have to remember to quote it too when manually writing queries - it's just extra work that's plain unnecessary. Plus if/when you encounter problems in the future, the first thing that people are going to see is the dot in the table/column names and question if that's what is causing the problem, as in problem-solving you always look for the obvious first. Why are you so insistent you want to use a dot? Can't you use underscores instead? Andy -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya Sent: Monday, 27 March, 2006 12:27 PM To: Jim C. Nasby Cc: Michael Fuhr; Postgres Subject: Re: [ADMIN] reg:create database oh.....ok Now, just because you can do this doesn't mean it's a very good idea... Why? From jnasby@pervasive.com Mon Mar 27 11:43:24 2006 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