pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
reg:create database
9+ messages / 5 participants
[nested] [flat]

* reg:create database
@ 2006-03-27 06:41 sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 9+ messages in thread

From: sandhya @ 2006-03-27 06:41 UTC (permalink / raw)
  To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>

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

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
@ 2006-03-27 06:45 ` Michael Fuhr <mike@fuhr.org>
  2006-03-27 09:33   ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
  0 siblings, 1 reply; 9+ messages in thread

From: Michael Fuhr @ 2006-03-27 06:45 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
@ 2006-03-27 09:33   ` sandhya <sandhyar@amiindia.co.in>
  2006-03-27 09:32     ` Re: reg:create database Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-03-27 10:38     ` Re: reg:create database Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 2 replies; 9+ messages in thread

From: sandhya @ 2006-03-27 09:33 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin

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
>





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
  2006-03-27 09:33   ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
@ 2006-03-27 09:32     ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-03-27 09:39       ` Re: reg:create database Kannan.S <skn@gsecone.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Andy Shellam @ 2006-03-27 09:32 UTC (permalink / raw)
  To: 'sandhya' <sandhyar@amiindia.co.in>; +Cc: pgsql-admin

> 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






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
  2006-03-27 09:33   ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 09:32     ` Re: reg:create database Andy Shellam <andy.shellam@mailnetwork.co.uk>
@ 2006-03-27 09:39       ` Kannan.S <skn@gsecone.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Kannan.S @ 2006-03-27 09:39 UTC (permalink / raw)
  To: andy.shellam@mailnetwork.co.uk; +Cc: 'sandhya' <sandhyar@amiindia.co.in>; pgsql-admin

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).******

Attachments:

skn.vcf (text/x-vcard, 886B) download 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
^ permalink raw reply [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
  2006-03-27 09:33   ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
@ 2006-03-27 10:38     ` Jim C. Nasby <jnasby@pervasive.com>
  2006-03-27 11:27       ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
  1 sibling, 1 reply; 9+ messages in thread

From: Jim C. Nasby @ 2006-03-27 10:38 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: Michael Fuhr <mike@fuhr.org>; pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
  2006-03-27 09:33   ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 10:38     ` Re: reg:create database Jim C. Nasby <jnasby@pervasive.com>
@ 2006-03-27 11:27       ` sandhya <sandhyar@amiindia.co.in>
  2006-03-27 11:36         ` Re: reg:create database Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-03-27 11:43         ` Re: reg:create database Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 2 replies; 9+ messages in thread

From: sandhya @ 2006-03-27 11:27 UTC (permalink / raw)
  To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: Michael Fuhr <mike@fuhr.org>; pgsql-admin

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
>





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
  2006-03-27 09:33   ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 10:38     ` Re: reg:create database Jim C. Nasby <jnasby@pervasive.com>
  2006-03-27 11:27       ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
@ 2006-03-27 11:36         ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
  1 sibling, 0 replies; 9+ messages in thread

From: Andy Shellam @ 2006-03-27 11:36 UTC (permalink / raw)
  To: 'sandhya' <sandhyar@amiindia.co.in>; +Cc: pgsql-admin

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?





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: reg:create database
  2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 06:45 ` Re: reg:create database Michael Fuhr <mike@fuhr.org>
  2006-03-27 09:33   ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
  2006-03-27 10:38     ` Re: reg:create database Jim C. Nasby <jnasby@pervasive.com>
  2006-03-27 11:27       ` Re: reg:create database sandhya <sandhyar@amiindia.co.in>
@ 2006-03-27 11:43         ` Jim C. Nasby <jnasby@pervasive.com>
  1 sibling, 0 replies; 9+ messages in thread

From: Jim C. Nasby @ 2006-03-27 11:43 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: Michael Fuhr <mike@fuhr.org>; pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2006-03-27 11:43 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-27 06:41 reg:create database sandhya <sandhyar@amiindia.co.in>
2006-03-27 06:45 ` Michael Fuhr <mike@fuhr.org>
2006-03-27 09:33   ` sandhya <sandhyar@amiindia.co.in>
2006-03-27 09:32     ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-03-27 09:39       ` Kannan.S <skn@gsecone.com>
2006-03-27 10:38     ` Jim C. Nasby <jnasby@pervasive.com>
2006-03-27 11:27       ` sandhya <sandhyar@amiindia.co.in>
2006-03-27 11:36         ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-03-27 11:43         ` Jim C. Nasby <jnasby@pervasive.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox