From: Josh Berkus <josh@agliodbs.com>
To: DAVID KUCHARSKI <dave@iemco.com>
To: josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Subject: Re: [NOVICE] update question
Date: Tue, 08 Oct 2002 08:39:45 -0700
Message-ID: <web-1775421@davinci.ethosmedia.com> (raw)
In-Reply-To: <3DA20957.B8E9A00A@iemco.com>
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 <dave@iemco.com> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, dave@iemco.com
Subject: Re: [NOVICE] update question
In-Reply-To: <web-1775421@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox