From: | "Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk> |
---|---|
To: | "'sandhya'" <sandhyar(at)amiindia(dot)co(dot)in> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: reg:create database |
Date: | 2006-03-27 11:36:16 |
Message-ID: | !&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAACS30yAbo18TIJewxjjoGkgAQAAAAA=@mailnetwork.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)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 | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-03-27 11:43:09 | Re: reg:create database |
Previous Message | sandhya | 2006-03-27 11:27:29 | Re: reg:create database |