trim(ing) during load process

From: Lynn(dot)Tilby(at)asu(dot)edu
To: pgsql-general(at)postgresql(dot)org
Subject: trim(ing) during load process
Date: 2003-10-28 20:12:46
Message-ID: 1067371966.3f9ecdbe1d285@webmail.asu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-10-28 20:13:51 Re: shared memory on OS X - 7.4beta4
Previous Message Ati Rosselet 2003-10-28 19:50:04 table locking.. FK tables locking on insert