Re: Tables/Columns in upper-case?

--- Stephen Frost <sfrost@snowman.net> wrote:
> * Andre Felipe Machado
> (andremachado@techforce.com.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.
> :)

Take a look at the Database Migration Wizard that
comes with PgAdminII (and PgAdminIII as well?  I
haven't checked that out).  Amongst its many handy
features, you can opt to lowercase all identifiers
(e.g. table names).  You should be able to find it via
http://pgadmin.postgresql.org .

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus