Re: [GENERAL] Role for CSV import

2011-05-16 Thread Tarlika Elisabeth Schmitz
On Sun, 15 May 2011 20:05:04 +0200 Cédric Villemain wrote: >2011/5/15 Rob Sargent : >> >> >> Tarlika Elisabeth Schmitz wrote: >>> >>> I have a database that will be populated solely by CSV import. >>> There are several CSV file formats, all denormalized.[...] > >pgloader may be useful: >http://pg

Re: [GENERAL] Role for CSV import

2011-05-15 Thread Tarlika Elisabeth Schmitz
On Sun, 15 May 2011 11:56:38 -0600 Rob Sargent wrote: >Tarlika Elisabeth Schmitz wrote: >> I have a database that will be populated solely by CSV import. >> There are several CSV file formats, all denormalized. >> >> I have created interim tables which match the CSV file formats. An >> insert tri

Re: [GENERAL] Role for CSV import

2011-05-15 Thread Cédric Villemain
2011/5/15 Rob Sargent : > > > Tarlika Elisabeth Schmitz wrote: >> >> I have a database that will be populated solely by CSV import. >> There are several CSV file formats, all denormalized. >> >> I have created interim tables which match the CSV file formats. An >> insert trigger distributes the dat

Re: [GENERAL] Role for CSV import

2011-05-15 Thread Rob Sargent
Tarlika Elisabeth Schmitz wrote: I have a database that will be populated solely by CSV import. There are several CSV file formats, all denormalized. I have created interim tables which match the CSV file formats. An insert trigger distributes the data to their appropriate destination tables.

[GENERAL] Role for CSV import

2011-05-15 Thread Tarlika Elisabeth Schmitz
I have a database that will be populated solely by CSV import. There are several CSV file formats, all denormalized. I have created interim tables which match the CSV file formats. An insert trigger distributes the data to their appropriate destination tables. The destination tables themselves hav