From: Michael Meskes <meskes@usa.net>
To: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Postgresql vs. Access97, TransferDatabase
Date: Thu, 26 Nov 1998 05:52:42 +0100
Message-ID: <19981126055242.A374@usa.net> (raw)
In-Reply-To: <18D7589E9C44D21199AC00805F31B04708A0BA@atlanta_nt2.atlanta.glenayre.com>
References: <18D7589E9C44D21199AC00805F31B04708A0BA@atlanta_nt2.atlanta.glenayre.com>
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.Meskes@datenrevision.de
home: Th.-Heuss-Str. 61, D-41812 Erkelenz, Michael.Meskes@usa.net
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@usa.net
Subject: Re: [INTERFACES] Postgresql vs. Access97, TransferDatabase
In-Reply-To: <19981126055242.A374@usa.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox