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

Re: [INTERFACES] Postgresql vs. Access97, TransferDatabase

From: Michael Meskes <meskes(at)usa(dot)net>
To: pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Postgresql vs. Access97, TransferDatabase
Date: 1998-11-26 04:52:42
Message-ID: 19981126055242.A374@usa.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Wed, Nov 25, 1998 at 03:55:37PM -0500, Gilley, Charles H. wrote:
> Okay, to provide some helpful feedback to others.... I readily admit that
> I am still a novice at this, so feel free to chime in and correct any 
> misunderstandings that I may have.
> 
> First, I've been trying to transfer a large dataset from access to postgres
> using a variety of methods:
> 
> ...
> 1) Cut and paste from access table to linked table:

Don't do this. It will run forever. Granted I never tried with postgres but
I tried with Oracle once some months ago and I'm pretty sure it will still
run hadn't I interrupted it. :-)

> 3) Export table - I believe this is the same as cutting/pasting except that
> it 

No, it is not the same. It is way faster.

Michael

-- 
Dr. Michael Meskes, Manager of the Western Branch Office, Datenrevision GmbH
work: Cuxhavener Str. 36, D-21149 Hamburg, Michael(dot)Meskes(at)datenrevision(dot)de
home: Th.-Heuss-Str. 61, D-41812 Erkelenz, Michael(dot)Meskes(at)usa(dot)net
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

pgsql-interfaces by date

Next:From: radarDate: 1998-11-26 06:29:32
Subject: unsubscribe
Previous:From: David HartwigDate: 1998-11-25 23:01:56
Subject: Re: [INTERFACES] Postgresql vs. Access97, TransferDatabase

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