Thread

1. Table names / mixed case / Postgresql 7.0.3

   Mathias Hohler <hohler@lasercomb.com> — 2001-04-12T09:41:07Z

   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 ?
   
   Best regards and
   thanks in advance
   
   Mathias
   
   
   

2. Re: Table names / mixed case / Postgresql 7.0.3

   Eric G. Miller <egm2@jps.net> — 2001-04-14T02:45:01Z

   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>
   
   

3. Re: Table names / mixed case / Postgresql 7.0.3

   Patrick Dunford <a47xxy@hotmail.com> — 2001-04-16T11:56:07Z

   On Sat, 14 Apr 2001 02:53:59 +0000 (UTC) AD in 
   comp.databases.postgresql.questions, Eric G. Miller said: 
   
   >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.
   
   Or be careful when using ODBC drivers - it doesn't bother changing the case 
   and then you are stuck with it :(
   
   
   -- 
   =======================================================================
   Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
   
      Then the end will come, when he hands over the kingdom to God
   the Father after he has destroyed all dominion, authority and
   power.
       -- 1 Corinthians 15:24
   http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010416
   =======================================================================
   Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/