Postgres Pro
Downloads
Home   >   mailing lists

trim(ing) during load process - Mailing list pgsql-general

From Lynn.Tilby@asu.edu
Subject trim(ing) during load process
Date
Msg-id 1067371966.3f9ecdbe1d285@webmail.asu.edu
Whole thread Raw
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: iant@the-wire.com (moonman)
Date:
Subject: Viewing linked large postgres tables with Access: Running out of memory
Next
From: Marco Colombo
Date:
Subject: Re: [OT] Choosing a scripting language.