If you don't mind an intermediate step you could use Pg2xbase
http://www.klaban.torun.pl/prog/pg2xbase/
This program takes dbf files and inputs them into Postgres. It has an option
for lower casing field names. You can specify the table name when you do the
conversion.
On Wednesday 15 November 2006 11:41 am, Dan Armbrust wrote:
> I'm trying to convert a database from either MS Access or MySQL into
> Postgres. I have found a couple of tools that will almost do what I
> want - but not quite. To make things match up with code that is already
> written - I need to have all of the table names and column names
> converted to lower case during the conversion process.
>
> I have found a couple of (free or demo) tools that will do it - navicat
> has a tools that will convert from MSAccess to Postgres - however, it
> doesn't offer a feature to lowercase all of the table names and column
> names.
>
> DB Tools Manager Professional will do it as well - but again, no way to
> tell it to lowercase things in the process.
>
> PGAdmin II had a tool that would do this - but alas - that part of
> PGAdmin was never brought into PGAdmin III. And the last version of
> PGAdmin II that I was able to find wouldn't run against my Postgres DB.
>
> Short of installing an older Postgres DB that PGAdmin II will work with
> - does anyone else know of a tool that can do what I want?
>
> Is there a script of some sort that I can run that would go through a
> set of tables and lowercase everything?
>
> Thanks,
>
> Dan
--
Adrian Klaver
aklaver@comcast.net