On Thu, Apr 12, 2001 at 11:41:07AM +0200, Mathias Hohler wrote:
> Hello,
>
> I think I`ve encoutered a problem in postgresql 7.0.3 (Linux). I want to
> be able to access tables, for instance, by typing select * from table.
> And it should be the same, whether the table name is TABLE or Table or
> table. But I found out, that you can create tables with the name TABLE
> or table and so on. Is there a way to fix this ?
> Maybe I`m wrong ?
Using double quotes around table names and column names makes them case
sensitive. Better to not do such a dastardly thing in the first place.
Otherwise they are all lowercased (as are queries provided the
identifier isn't quoted).
--
Eric G. Miller <egm2@jps.net>