Re: Re[2]: Importing Data into Postgresql from MS Access

From: <bmccoy(at)chapelperilous(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jean-Christophe Boggio <cat(at)thefreecat(dot)org>, Tony Simopoulos <karkalis(at)earthling(dot)net>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Re[2]: Importing Data into Postgresql from MS Access
Date: 2000-10-13 01:25:51
Message-ID: Pine.LNX.4.10.10010122124320.18603-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, 12 Oct 2000, Tom Lane wrote:

> I agree with Tony that a separate tool for format conversions would be
> mighty handy. I don't think that trying to load down COPY with more
> features is an appropriate approach --- let it do what it does well,
> namely database backup and restore. But we do need something that can
> handle the layout and data-conversion tasks needed to import data from
> other DBMSes.

How about a PostgreSQL equivalent of something like Oracle's SQL*Loader?
You still have to create control files and do some manual stuff, but it is
a very powerful utility.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
I always wake up at the crack of ice.
-- Joe E. Lewis

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message S.A.Pamungkas 2000-10-13 01:33:16 Re: download postgresql for windows
Previous Message Anthony E . Greene 2000-10-13 01:05:18 Re: Need more help on data bases over a intranet