On Thu, Nov 16, 2006 at 06:23:23PM -0700, Jim Nasby wrote:
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
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
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
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