Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike G.
Sent: Thursday, February 09, 2006 2:21 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Update table with data from another table
Hi,
I was hoping to update the results of one table with data from another
Hi,
I was hoping to update the results of one table with data from another table.
I have done this many times before using UPDATE X SET Z FROM Y.
The catch this time is the tables involved both have the same column names,
same table names but reside in different schemas.
UPDATE schema1.A
SET