Re: [GENERAL] Update table with data from another table

2006-02-09 Thread Chandra Sekhar Surapaneni
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

[GENERAL] Update table with data from another table

2006-02-09 Thread Mike G.
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