[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Talking to Postgres from C

This probably belongs on the -devel list, but here is an outline to
how I would do it:

1)  Upload the csv files to a holding table in the db with a structure
the same as the file

2)  Update the prices (either parts or vendorparts) from that table
(update foo set bar = (select bar from baz where foo.sku = bar.sky)
where sku in (select sku from baz) or something along those lines).

Best Wishes,
Chris Travers