Testing / debuging data import
От
Brendon Gleeson
Тема
Testing / debuging data import
Дата
Msg-id
45235CD6.6050702@gleesonprop.co.za
Список
Дерево обсуждения
Testing / debuging data import Brendon Gleeson <brendon@gleesonprop.co.za>
Re: Testing / debuging data import Michael Fuhr <mike@fuhr.org>
Re: Testing / debuging data import "Shoaib Mir" <shoaibmir@gmail.com>
Hi All, I am in the process of migrating all my data from MySQL to Postgres. I am getting errors during the data import (non critical), my data is ending up a couple of rows short. This is probably to be expected considering that MySQL doesn't have much respect for data type constaints. Basically what I want to do is simulate a data import (from a file with full insert statements and no table creation), I want the offending record/line to be printed to stdout with a verbose / helpful error. I would preferbly like to use psql from the command line, eg: $ psql [OPTIONS] < data.sql
В списке pgsql-novice по дате отправления