> take advantage of it's strengths and create a second table...

Actually, this IS the second table. 8)
The first table consist of an inventory_id, product_id, and quantity.

> Another simpler option is to remove the unique restraints on Prod_id and just add multiple rows to the table...

Unfortunately I cannot add many rows to the second table as I have MANY entries to INSERT.

> so Postgress has an "array" type?

Yes, just create a column as *usual* but use quare-brackets to specify the dimensions of the array.

Since the only mention of perl on this last posting came from THIS sentence, I think I'll stop.
Thanks everyone for the ideas. 8)