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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2004-01-22 14:59:25 | Re: Adding long text to a text field generates an error |
Previous Message | Hiroshi Inoue | 2004-01-22 14:47:31 | Re: OpenOffice: SetPos with data_at_exec not yet supported |