Updating in multiple tables

From: Luuk Jansen <subscribe(at)angelosystems(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Updating in multiple tables
Date: 2006-03-20 14:26:57
Message-ID: 1142864817.3554.20.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2006-03-20 14:31:31 Re: Wal -long transaction
Previous Message Vladimira Nitrova 2006-03-20 13:17:05 Licensing of .DLL files