| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Data conversion tools? |
| Date: | 2006-11-17 01:23:23 |
| Message-ID: | 45692242-B73E-4ECB-9F16-FD31F57518DB@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Nov 15, 2006, at 12:41 PM, 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.
Well, for tables it wouldn't be hard to craft a query that spits out
the appropriate ALTER TABLE RENAME statements. Unfortunately, ALTER
TABLE doesn't support renaming columns, but it might be safe to run
an update on the system tables to accomplish that.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory S. Williamson | 2006-11-17 01:57:55 | Eliminating bad characters from a database for upgrading from 7.4 to 8.1 |
| Previous Message | Jim Nasby | 2006-11-17 01:20:34 | Re: Discover temporary INDEX/TABLE name |