Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group