David, I'm sorry, you just don't seem to be at the "self-help" stage. I strongly reccommend that you hire a database consultant to help you.
-Josh Berkus DAVID KUCHARSKI <[EMAIL PROTECTED]> wrote: > the result set of the view is 3628 lines. It would be > nice if postgres could do this update instead of our > data entry person. > > > Josh Berkus wrote: > > > > David, > > > > > > > > 1) Is there any way you can easily identify the relevant > rows in the > > > > legacy > > > > > > database and export only those? > > > > > > I guess I'm unclear as to which table you are > > > referring to as the LEGACY table. either way i > > > imagine that by looking at a table or VIEW of the pik > > > numbers common to both tables is what i need, so yes I > > > can get that. in fact i have now. but how can i use > > > that table to update the price fields in inventory > > > > No, I'm talking about the database system that is exporting to > text. Can you > > tell it to export only the rows you need? > > > > -- > > -Josh Berkus > > Aglio Database Solutions > > San Francisco > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org