Home > mailing lists

Update field to a column from another table - Mailing list pgsql-general

From	drum.lucas@gmail.com
Subject	Update field to a column from another table
Date	April 21, 2016 08:10:39
Msg-id	CAE_gQfWFAvW+k4GdPWFQAuVBr_4TSRx7vpPEzSTeWf1WjkJrww@mail.gmail.com Whole thread Raw
Responses	Re: Update field to a column from another table
List	pgsql-general

I've got two tables:

- ja_jobs

- junk.ja_jobs_23856

I need to update the null column ja_jobs.time_job with the data from the table junk.ja_jobs_23856

So I'm doing:

UPDATE public.ja_jobs AS b
SET time_job = a.time_job
FROM junk.ja_jobs_23856 AS a
WHERE a.id = b.id
AND a.clientid = b.clientid;

But it's now working... I'm using PostgreSQL 9.2

Do you guys have an idea why?

cheers;

Lucas

From: John R Pierce
Date: 21 April 2016, 06:24:17
Subject: Re: Is it possible to call Postgres directly?

From: "Charles Clavadetscher"
Date: 21 April 2016, 08:54:07
Subject: Re: Update field to a column from another table