Re: Problem with table name in capitals.

> -----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.