X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 75228D1B8DF for ; Tue, 2 Mar 2004 04:43:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18830-07 for ; Tue, 2 Mar 2004 00:43:05 -0400 (AST) Received: from mail.canberra.edu.au (mail.canberra.edu.au [137.92.97.81]) by svr1.postgresql.org (Postfix) with ESMTP id CEA26D1B4B8 for ; Tue, 2 Mar 2004 00:42:53 -0400 (AST) Received: from isd.canberra.edu.au (fooey.canberra.edu.au [137.92.10.57]) by mail.canberra.edu.au (iPlanet Messaging Server 5.2 Patch 1 (built Aug 19 2002)) with ESMTP id <0HTX001ECMFMTU@mail.canberra.edu.au> for pgsql-sql@postgresql.org; Tue, 02 Mar 2004 15:42:58 +1100 (EST) Date: Tue, 02 Mar 2004 15:42:58 +1100 From: Terence Kearns Subject: scripts for converting postgres to oracle? To: pgsql-sql@postgresql.org Message-id: <404410D2.4040909@isd.canberra.edu.au> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-au, en-gb, en, en-us User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20030925 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/18 X-Sequence-Number: 17117 Hi there, We use oracle at work but I use postgres at home. I also sometimes develop something in postgres for use at work because I don't really want to run oracle (9i Lite won't install) on my laptop. At the moment, I'm hacking a nasty php script which converts a pgdump file which will work for a particular database. Does anyone have something pre-made which will *assist* with a postgres to oracle conversion? -- Terence Kearns ~ ph: +61 2 6201 5516 IT Database/Applications Developer Enterprise Information Systems Client Services Division University of Canberra www.canberra.edu.au