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

Re: Tables/Columns in upper-case?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Andre Felipe Machado <andremachado(at)techforce(dot)com(dot)br>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Tables/Columns in upper-case?
Date: 2004-01-21 23:17:57
Message-ID: 20040121231757.GG1464@ns.snowman.net (view raw or flat)
Thread:
Lists: pgsql-odbc
* Andre Felipe Machado (andremachado(at)techforce(dot)com(dot)br) wrote:
> I guess that it is an Access issue or its MS driver, because I use OpenOffice 
> 1.1 connected to a PostgreSQL through odbc and can use upper or lower case.

That just means openoffice must do the upper->lower conversion for you.

> Actually, odbc adds double quotes in sql commands to encapsulate upper case 
> names in order to work in pg.

Hrm, so you can use ""'s around things in psql to maniuplate those
tables?  That's kind of annoying, but might be manageable (at least, to
rename the tables).

> It will be not a good idea to incorporate specific programs "features" into a 
> generic driver manager. Maybe into an Access odbc driver...

Eh.

> Suggestion:
> After exporting to PostgreSQL, execute a dump to a text file.
> Then, edit it to use only lower case and execute the sql into pg to create new 
> lowercase tables.

That'd be rather silly when I can just rename them by putting the table
name in ""s.  That's kind of annoying though, imv. :)

Thanks,

	Stephen

In response to

Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2004-01-22 00:09:47
Subject: Re: Tables/Columns in upper-case?
Previous:From: Stephen FrostDate: 2004-01-21 22:54:48
Subject: Tables/Columns in upper-case?

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