Thread: reg:create database

reg:create database

From
"sandhya"
Date:
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

Re: reg:create database

From
Michael Fuhr
Date:
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

Re: reg:create database

From
"sandhya"
Date:
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" <mike@fuhr.org>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: "Postgres" <pgsql-admin@postgresql.org>
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
>



Re: reg:create database

From
"Andy Shellam"
Date:
> 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




Re: reg:create database

From
"Kannan.S"
Date:
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
thismail, please delete it immediately and notify the sender. Unauthorised copying, disclosure or distribution of the
materialin 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).****** 



Attachment

Re: reg:create database

From
"Jim C. Nasby"
Date:
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

Re: reg:create database

From
"sandhya"
Date:
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" <jnasby@pervasive.com>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: "Michael Fuhr" <mike@fuhr.org>; "Postgres" <pgsql-admin@postgresql.org>
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
>



Re: reg:create database

From
"Andy Shellam"
Date:
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?



Re: reg:create database

From
"Jim C. Nasby"
Date:
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