Обсуждение: trim(ing) during load process

Поиск
Список
Период
Сортировка

trim(ing) during load process

От
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