Re: Tables/Columns in upper-case?

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