pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedreg: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