From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
Cc: | anderson earley <anderson_earley(at)yahoo(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: QUERY |
Date: | 2012-03-13 19:52:21 |
Message-ID: | CAHyXU0zx+yE9NJjzHcsTkvL24KM8N4-QHDfoiqu=9xnx0B=CfA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Mar 13, 2012 at 1:26 PM, Rory Campbell-Lange
<rory(at)campbell-lange(dot)net> wrote:
> On 13/03/12, anderson earley (anderson_earley(at)yahoo(dot)com) wrote:
>> I need a script that parses a provided users.txt, then it needs to
>> look for users in 'NEW USERS' table and move any to their 'intended'
>> group.
>
> That is not a terribly helpful description of what you want to do, as
> you haven't provided many details.
>
> Do you mean you need to run an SQL statement along the lines of:
>
> INSERT INTO group_users
> (person_id, group_id)
> VALUES
> (pid, gid);
>
> and you want to work out how to generate that sort of statement from a
> text file containing (presumably) the equivalent of 'pid' and 'gid'?
you are apparently unaware of my 'parse any file into any intended
location' script.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej | 2012-03-13 19:55:31 | Re: Updating RHEL4 system for PHP; requires Postgresql updates |
Previous Message | Andreas Kretschmer | 2012-03-13 19:52:17 | Re: Using pg_trgm |