I use the PgSqlLoader class to load many data on postegres from DataTable:
' Table as a Populated DataTable
blk.Open()
blk.LoadTable(Table)
blk.Close()
blk.Dispose()
A column of Datatable contain text with carriage return and when i attempt to load in postegres an error occur:
"literal carriage return found in data"
How can i bypass the problem?
tnks
PgSqlLoader and CRLF
New build of dotConnect for PostgreSQL 5.30.165 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21150 .
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21150 .