[vox-tech] PostGreSQL: COPY FROM syntax

[Dylan Beaudette]

Hi everyone,

I am attempting to load in some data files into pgsql, however the COPY FROM 
function is not allowing insertion of records that do not match the column 
types. i.e. if a column in the input text file is quoted, then it is 
interpreted as a string, and therefore an illegal entry into an integer 
field.

is there anyway to force coercion to the column definition at load time?

any ideas?

Thanks in advance!


-- 
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341