Re: [GENERAL] Need help doing a CSV import

2010-07-14 Thread Tim Landscheidt
David Fetter wrote: > [...] >> Another option is a small Perl script or something similar >> that connects to both the FoxPro and the PostgreSQL database >> and transfers the data with parameterized "INSERT". The ad- >> vantage of this is that you have tight control of charsets, >> date formats,

Re: [GENERAL] Need help doing a CSV import

2010-07-14 Thread David Fetter
On Wed, Jul 14, 2010 at 01:20:25PM +, Tim Landscheidt wrote: > Craig Ringer wrote: > > >> I am in the process of moving a FoxPro based system to PostgreSQL. > > >> We have several tables that have memo fields which contain carriage > >> returns and line feeds that I need to preserve. I thoug

Re: [GENERAL] Need help doing a CSV import

2010-07-14 Thread Tim Landscheidt
Craig Ringer wrote: >> I am in the process of moving a FoxPro based system to PostgreSQL. >> We have several tables that have memo fields which contain carriage >> returns and line feeds that I need to preserve. I thought if I converted >> these into the appropriate \r and \n codes that they wou

Re: [GENERAL] Need help doing a CSV import

2010-07-14 Thread Craig Ringer
On 14/07/2010 7:04 PM, t...@exquisiteimages.com wrote: I am in the process of moving a FoxPro based system to PostgreSQL. We have several tables that have memo fields which contain carriage returns and line feeds that I need to preserve. I thought if I converted these into the appropriate \r and

[GENERAL] Need help doing a CSV import

2010-07-14 Thread tony
I am in the process of moving a FoxPro based system to PostgreSQL. We have several tables that have memo fields which contain carriage returns and line feeds that I need to preserve. I thought if I converted these into the appropriate \r and \n codes that they would be imported as carriage returns