Re: OT: Software that will populate a database from csv data?
On Sat, Jul 23, 2011 at 1:11 PM, Liam O'Toole <otoolel@otoole.dyndns.org> wrote:
> In gmane.linux.debian.user, you wrote:
>> I'm looking for software that will accept as input a csv file and a database
>> schema and will populate the database with the data in the csv. I'm not talking
>> about something simple that will fill a single table, but rather something that
>> can work foreign key constraints and can respect one-to-many, many-to-one and
>> many-to-many relations.
>
> I don't have an answer to your question but I have to ask: how do expect
> to express all of the above in a simple CSV file?
The data will be in the CSV file. The database schema will be needed
as well, along
with a mapping of CSV columns to database table columns.
Reply to: