Updating in multiple tables - Mailing list pgsql-general

From Luuk Jansen
Subject Updating in multiple tables
Date
Msg-id 1142864817.3554.20.camel@localhost.localdomain
Whole thread Raw
Responses Re: Updating in multiple tables  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
I have a quick newbee question:

Is is possible to update in multiple tables at the same time.
I am working with PHP scripts and will use the following example to
explain what I want to do:

I have a generic_user tables, which forms a INNER JOIN with the
logon_user table (with a join using id).

generic_user:
- id
- name
- passowrd

logon_user:
- id
- last_logon
- nickname

As I load all the fields at once in an array, and want to update the
same, so just something like

"UPDATE generic_user INNER JOIN logon_user USING (id) SET name='test',
nickname='test2' WHERE id = 1";

Is there anybody who can explain how to do this?

Thanks in advance,
Regards,
Luuk


pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: Urgent !!! Please Help Me
Next
From: Tino Wildenhain
Date:
Subject: Re: Updating in multiple tables