Re: mysql to postgresql
| From: | Teodor Cimpoesu | Date: | Tue, 13 Jun 2000 04:35:31 +0000 |
| Subject: | Re: mysql to postgresql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-364@lists.php.net to get a copy of this message | ||
Hi Carlos!
On Mon, 12 Jun 2000, Carlos Henrique wrote:
> I need to get all my data in a mysql database and put it on a postgresql
> database. The dump script generated from mysql doesnt work on the postgres.
> Some tip to help me?
You can either use -c (for complete insert statements, which *should*
be portable) or -T (for tab separated records).
In the first case you can simply use psql, in the second, COPY FROM
FILE <file> USING DELIMITERS '<delim>', where <delim> is what you
specified with -T.
Note that table creation may be different, in which case you
should adjust it before feeding it to postgres.
-- teodor