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).
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 .