trim(ing) during load process

Started by Nonameover 22 years ago1 messagesgeneral
Jump to latest
#1Noname
Lynn.Tilby@asu.edu

I have variable length strings in records in a flat ascii
file I need to "trim" before or during load of the file
to a table using psql embedded in C. What is the best
way to accomplish this?

Is there perhaps a variable type I should use other than
varchar, that will accomplish this for me?

Thanks for your help!
Lynn Tilby