7 DROP TABLE legacy_pre_cat;
8 CREATE TABLE legacy_pre_cat (barcode text, lib text, title text, author text);
9 COPY legacy_pre_cat (barcode, lib, title, author) FROM STDIN;
14 my ($bc,$l,$t,$a) = split '\|';
16 print "$bc\t$l\t$t\t$a\n";
20 print "CREATE INDEX precat_bc_idx ON legacy_pre_cat (barcode);\n";