Re: [GENERAL] Oracle to Pg tool

2001-05-10 Thread Gilles DAROLD
Hi, Another point regarding /contrib or other directory like /tools is to centralize tools for Pg. Also I can't be sure to always have an URL. This one is dependant on the company I'm working now. Life is moving. Regards Bruce Momjian wrote: [ Charset US-ASCII unsupported, converting... ]

[GENERAL] Oracle to Pg tool

2001-05-09 Thread Gilles DAROLD
Hi, As I previous searched a tool to convert Oracle database to PostgreSQL and really found nothing, there's now a piece of perl code I've written that can become a great tool to do this job. It currently extract the database schema table definition of an Oracle database and output a sql script

Re: [GENERAL] Oracle to Pg tool

2001-05-09 Thread Gilles DAROLD
Add on on ora2pg. Table grant extraction is done. It is based on group/users grants. Oracle has ROLES that I understand as groups and users associated to these roles. So I create a group for each role and alter it by adding the users. And then set grants to each tables. Let me now if I have

Re: [GENERAL] Oracle to Pg tool

2001-05-09 Thread Vince Vielhaber
On Wed, 9 May 2001, Bruce Momjian wrote: Where do people want this. Should it be in /contrib or on its own web page? This is already linked on the related page. I have an Xbase conversion utility too. Where should that go? What's the URL? Hi, As I previous searched a tool to