Hello !
I have to transfert data from MS-Access to
PostgreSQL 8.03 under Windows 2003 server.
Text fields may contain a carriage return
(CR-LF).
I use the copy instruction.
Under Pg-Admin III 1.21, I obtain an error message
for that carriage return and a hint : use \n.
If I use a filter on
on 5/30/05 2:19 AM, [EMAIL PROTECTED] purportedly said:
> I have to transfert data from MS-Access to PostgreSQL 8.03 under Windows 2003
> server.
> Text fields may contain a carriage return (CR-LF).
> I use the copy instruction.
> Under Pg-Admin III 1.21, I obtain an error message for that carriag
In my experience, there is no way to tell an embedded carriage return
from and end-of-record carriage return other than counting intervening
tabs.
What I do, is fix it in access with a query for (believe it or not)
"*" & chr(13) & "*"
which returns all records that contain a CR. I then just del