Skip site navigation (1) Skip section navigation (2)

Re: Problem with table name in capitals.

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Kurt Roeckx" <Q(at)ping(dot)be>,"Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Problem with table name in capitals.
Date: 2002-12-14 19:54:48
Message-ID: 03AF4E498C591348A42FC93DEA9661B8128D70@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Kurt Roeckx [mailto:Q(at)ping(dot)be] 
> Sent: 14 December 2002 13:08
> To: Jeff Eckermann
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Problem with table name in capitals.
> 
> 
> On Fri, Dec 13, 2002 at 08:17:01PM -0800, Jeff Eckermann wrote:
> > 
> > You will need to rename your
> > tables/columns to lower case names, or always quote
> > them in queries.
> 
> So if I get this right, the problem was that there were 
> quotes when it was created.  So I should blame pgadmin for doing that?

No, 'cos pgAdmin hasn't done anything wrong. You are quite entitled to
use mixed case identifiers if you like, and pgAdmin will allow you to do
so. If your client application cannot then deal with that, then it;s
hardly the fault of pgAdmin.

> You can't really put quotes around the names of the 
> tables/column when you're still in that wizard.

If the wizard you're referring to is the pgAdmin Migration Wizard, then
it will use mixed case names by default, but on the very first page of
the wizard, there are options to fold the names to lower case for you.

Regards, Dave.

Responses

pgsql-odbc by date

Next:From: Kurt RoeckxDate: 2002-12-14 21:04:37
Subject: Re: Problem with table name in capitals.
Previous:From: Kurt RoeckxDate: 2002-12-14 13:08:23
Subject: Re: Problem with table name in capitals.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group