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
nameIs there any possibility of doing it?If yes pls tell me.

See the documentation regarding quoted identifiers.

#SQL-SYNTAX-IDENTIFIERS

Dear Michale
I am unable to get answer from the link you sentJust tell me whether
it is possible or not.
In the document they mentioned that . is used as a seperator for a
table/column nameSo Is it any way to use dot while creating a
table/database

Message
From: "Michael Fuhr" <mike (AT) fuhr (DOT) org>
To: "sandhya" <sandhyar (AT) amiindia (DOT) co.in>
Cc: "Postgres" <pgsql-admin (AT) postgresql (DOT) org>
Sent: Monday, March 27, 2006 12:15 PM
Subject: Re: [ADMIN] reg:create database

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
nameIs there any possibility of doing it?If yes pls tell me.

See the documentation regarding quoted identifiers.
--
#SQL-SYNTAX-IDENTIFIERS

Mon, Mar 27, 2006 at 03:03:38PM +0530, sandhya wrote:
Dear Michale
I am unable to get answer from the link you sentJust tell me whether
it is possible or not.
In the document they mentioned that . is used as a seperator for a
table/column nameSo 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

ohok
Now, just because you can do this doesn't mean it's a very good idea
Why?

Message
From: "Jim C. Nasby" <jnasby (AT) pervasive (DOT) com>
To: "sandhya" <sandhyar (AT) amiindia (DOT) co.in>
Cc: "Michael Fuhr" <mike (AT) fuhr (DOT) org>; "Postgres" <pgsql-admin (AT) postgresql (DOT) org>
Sent: Monday, March 27, 2006 4:08 PM
Subject: Re: [ADMIN] reg:create database

Mon, Mar 27, 2006 at 03:03:38PM +0530, sandhya wrote:
Dear Michale
I am unable to get answer from the link you sentJust tell me
whether
it is possible or not.
In the document they mentioned that . is used as a seperator for a
table/column nameSo 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

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 nameSo 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
ohok
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:
Granted, PostgreSQL doesn't
(currently) allow you to do per-database specifications, but that could
change. In any case, it's asking for trouble.