Received: from as.tksoft.com (gyw.com [206.117.28.161] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id OAA92651 for ; Wed, 25 Aug 1999 14:00:51 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id KAA02838; Wed, 25 Aug 1999 10:50:03 -0700 From: "tjk@tksoft.com" Message-Id: <199908251750.KAA02838@uno.tksoft.com> Subject: Re: [SQL] Dumping Oracle tables into Postgres To: caffeine@toodarkpark.org (Howie) Date: Wed, 25 Aug 1999 10:50:03 -0700 (PDT) Cc: pgsql-sql@postgreSQL.org In-Reply-To: from "Howie" at Aug 25, 99 01:29:56 pm Content-Type: text Esteban, Just one way of doing it, but export the tables as comma/tab delimited files, or using whatever delimeter is easy for you, and then use Postgres' copy command to import the data into a Postgres table(s). See under COPY in the user documentation for your options, syntax, etc.. Anyway, the idea is to write the data into a text file, and then either modify the text file to contain the copy commands, or do it from a script, or even do it manually with psql. Once the data is inside postgres, you can tweak it to your heart's content. Troy > > On Tue, 24 Aug 1999, Esteban Chiner Sanz wrote: > > > What's the easiest (fastest) way for dumping Oracle tables into Postgres > > tables? > > Thank you, > > a quickie perl+DBI script solved that for me... ill have to check to see > how portable it is... i know the sid, username, passwd were all > hardcoded... > > --- > Howie URL: http://www.toodarkpark.org > "The distance between insanity and genius is measured only by success." > > > ************ > >