Creating a PGSQL database from a msql database

From: "Jonathan R(dot) Karlen" <jkarlen(at)karlen(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Creating a PGSQL database from a msql database
Date: 1999-08-11 16:42:51
Message-ID: 3.0.6.32.19990811114251.007f0ec0@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I have a msql database that I want to use to create a similar PGSQL
database. The primary diference in the new version is that the contents of
what was one table in the old database will be 3 in the new.

I wrote a PHP3 script to select from the existing msql database the fields
that are going into the new table and create INSERT statements for every
record. The statements look fine. However, when I try to run that file
through the monitor using \i it gives a large amount of errors. Also,
interestingly, on records where no error is return the INSERT still doesn't
occur.

Any help and advice would be appreciated. I can send the text file of the
INSERT statements to anyone who wants to help.

Thanks.

Jonathan Karlen
**********************************************************
Jonathan R. Karlen
Karlen Internet Solutions
jkarlen(at)karlen(dot)com
http://www.karlen.com

Browse pgsql-general by date

  From Date Subject
Next Message sumi 1999-08-11 17:44:04 running postgresql
Previous Message Roberto Moreda 1999-08-11 16:31:12 How to manage processes in the backend?