From: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
---|---|
To: | anderson earley <anderson_earley(at)yahoo(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: QUERY |
Date: | 2012-03-13 18:26:10 |
Message-ID: | 20120313182610.GA1045@campbell-lange.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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'?
Rory
--
Rory Campbell-Lange
rory(at)campbell-lange(dot)net
Campbell-Lange Workshop
www.campbell-lange.net
0207 6311 555
3 Tottenham Street London W1T 2AF
Registered in England No. 04551928
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2012-03-13 19:52:17 | Re: Using pg_trgm |
Previous Message | anderson earley | 2012-03-13 18:20:33 | QUERY |