Hello,

I'm in the process of migrating a database from MS SQL to a free
database. I just managed to convert the Tables and data to
PostgreSQL, but not the stored procedures, thought. They are
quite different.

So I tried to migrate the stuff to InterBase 6 under Linux.

The pg_dump feature of PostgreSQL dumped the table definitions
and I tried to convert them by hand. Only minor changes are
required. Unfortunately I had to rename some columns which were
named "Action" and "Sort". I guess they have a special meaning in
InterBase because I wasn't able to insert those names.

My question is if there is a sane way to insert the data
once the tables are created. I guess I would manage to rename
the PostgreSQL column definition names equal to the InterBase
ones to avoid the special names.

Is there a similar mechanism to the
pg_dump | psql
thing of PostgreSQL? Would it be more easy to migrate the data
(or the whole thing) from MS SQL-Server.

Kind regards

Andreas.