From: brad <brad@kieser.net>
To: Max Pyziur <pyz@panix.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database conversion
Date: Sun, 16 Apr 2000 21:40:08 +0100
Message-ID: <38FA2528.5238E28B@kieser.net> (raw)
References: <38F1E3AE.DEFC331E@webgadgets.co.uk>
<38FA1C5C.E2447EA3@panix.com>
I have had problems with the pg_dump command, though, when the tables have
been wide (many columns with long text items in them) and deep (many rows).
The pg_dump utility reloads the data from the stdin, using a pipe.
This doesn't work too well (i.e. no data gets loaded) for these tables, but
is fine for smaller tables.
I use linux - nearly every release of kernel 2.0 and 2.2.
Max Pyziur wrote:
> Steve Murphy wrote:
> >
> > Hi,
> >
> > Does anyone know of any conversion programs that will either convert an
> > MS Access database file to a Postresql database or from a Filemaker Pro
> > database file to a Postresql database for the Red Hat Linux OS?
> >
> > Any help or educated guesses of where to start looking would be
> > extremely welcome.
>
> Apologies that this reply is coming possibly a bit late.
>
> My experience is essentially limited to Postgres, Informix, and
> Foxpro, the last in which I haven't done any development in a while.
>
> General procedure that I know of is:
> 1 - dump the schema of one to a file and tweak it so that it conforms
> to the standards of the target database server
> 2 - dump the data to a pipe-delimited text file
> 3 - use the schema from the source database program to create a
> database in the target database program/server
> 4 - import the pipe-delimited data.
>
> In the case of Informix and Postgres, both have utilities (dbschema
> and pg_dump with the -s flag, respectively) which allow you to output
> a databases schema to stdout or a file. I know that with Foxpro 3.0
> there was some sort of schema utility included somewhere. Informix
> has an SQL command called UNLOAD which allows you to dump data to
> pipe-delimited formats; pg_dump -a dumps the data in postgres; COPY in
> the postgres monitor gives you a little more control as to the format
> of data dump. Informix's syntax is a cleaner implementation in this
> regard, though. Postgres's pg_dump is great, though, for backing up a
> whole database w/ schema and restoring it.
>
> So I only gave you half an answer since I didn't address your MS
> Access or Filemaker pro issues. I suspect though you can do exports
> and control the format in some way.
>
> > Thanx, Steve.
>
> --
> Max Pyziur BRAMA - Gateway Ukraine
> pyz@brama.com http://www.brama.com/
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-admin@postgresql.org
Cc: brad@kieser.net, pyz@panix.com
Subject: Re: Database conversion
In-Reply-To: <38FA2528.5238E28B@kieser.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