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

Re: Tables/Columns in upper-case?

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Ben Ramsey <br(at)benandliz(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Tables/Columns in upper-case?
Date: 2004-01-22 14:50:20
Message-ID: 20040122145021.44120.qmail@web20807.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- Ben Ramsey <br(at)benandliz(dot)com> wrote:
> We used PgAdminIII to migrate an Access database to
> PostgreSQL, but I 
> believe that we had to set all the table names to
> lowercase in Access 
> before we migrated it.  It did, however,
> automatically set our column 
> names to lowercase for us.  Consequently, if we
> didn't set the table 
> names to lowercase in Access before migrating, then
> we had to place 
> single quotes around the table names in all of our
> SQL statements (which 
> continued to use the capital letters in them), but
> if we set the table 
> names to lowercase before the migration, then we
> didn't have to put the 
> single quotes around the table names in our SQL
> statements when they 
> were hitting the Postgres DB (despite the fact that
> the names in the SQL 
> statements retained the capitalization as defined in
> the Access table... 
> weirdness).

With PgAdminII's Migration Wizard, none of this is
necessary.  Dave Page confirms in a separate email
that the Wizard has not yet been implemented in
PgAdminIII, which is a pity, seeing that III is
otherwise the "latest and greatest".

> 
> Jeff Eckermann wrote:
> > 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 .
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2004-01-22 14:59:25
Subject: Re: Adding long text to a text field generates an error
Previous:From: Hiroshi InoueDate: 2004-01-22 14:47:31
Subject: Re: OpenOffice: SetPos with data_at_exec not yet supported

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