| 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: | Whole Thread | Raw Message | 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 |