From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Migrating Data from MySQL to PostgreSQL |
Date: | 2011-05-05 23:35:52 |
Message-ID: | alpine.LNX.2.00.1105051630430.16080@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
There is an interesting database we need for a project that is
downloadable as the equivalent of postgres' pg_dumpall. The file contains
the DDL for the tables and supporting features and there are 19 separate
files containing the data with the pipe symbol separating attributes. Before
I upset psql I want to check my thinking with you experts.
I modified the DDL statements to remove the apparently MySQL-specific calls
to a database engine, and I modified the data load statements to use the
postgres copy command.
My question is whether I need to prepend a slash to the copy command as I
would when running it from the command line.
I'll be happy to provide samples and further information if that's
desired.
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Lacey L. Powers | 2011-05-05 23:48:25 | Re: Migrating Data from MySQL to PostgreSQL |
Previous Message | Rich Shepard | 2011-05-05 22:48:03 | Re: Any Excel Experts |