Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0OFZDq19558 for ; Wed, 24 Jan 2001 10:35:13 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0OFYT912308; Wed, 24 Jan 2001 10:34:29 -0500 (EST) To: Ramesh H R cc: sqllist Subject: Re: How to change the ownership of the table? In-reply-to: <3A6E9C97.44063CB9@easi.soft.net> References: <3A6E9C97.44063CB9@easi.soft.net> Comments: In-reply-to Ramesh H R message dated "Wed, 24 Jan 2001 14:42:55 +0530" Date: Wed, 24 Jan 2001 10:34:29 -0500 Message-ID: <12305.980350469@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/329 X-Sequence-Number: 1002 Ramesh H R writes: > Please, any one guide me how to change the ownership of the table? There's an ALTER TABLE command for this in current sources, but I think it's new in 7.1. In older releases, you have to reach in by hand and change the 'relowner' field of the table's pg_class row to match the 'usesysid' field of the pg_shadow entry for the desired new owner. Working out the exact UPDATE command to use is left as an exercise for the student ;-) regards, tom lane