Is there any way to make copy work with fixed width files?
eg
create table t1 (code char(5), description char(30));
copy t1 from '/tmp/afile' delimiter as <nothing?>
where afile looks something like
00001test16789012345678901234567890
00002test26789012345678901234567890
00003test36789012345678901234567890
at the moment i have a function that does
create temp table tmp1 (line text);
copy tmp1 from '/tmp/afile';
<bunch of code to create a view of tmp1 with lots of substrings from
looking at information schema for t1 definition>
<it used to do the substrings in the plpgsql but it was orders of
magnitude quicker to use the view>
insert into t1 select * from tmpview;
klint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@xxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings