Hi Bront,

Although it looks like TEXT is unlimited in PostgreSQL, it does have a limit of 1GB, which is still huge.

http://www.postgresql.org/docs/current/interactive/datatype-character.html

And you are right, there is no equivalent datatype in SAS that works with TEXT from PostgreSQL due to the enormousness of TEXT.

http://support.sas.com/documentation/cdl/en/ds2ref/68056/HTML/default/viewer.htm#p00lvj8tbbkdozn1vwe0s7wgh5m8.htm

I'll have this looked into, but the only thing that I can personally think of is to import everything except for that one TEXT column, split that column across multiple columns with a varchar datatype, then import those into your DB. Kind of ugly, but effective.

I'll circle back with you on what I find out.

Regards,

Jon