Re: How to change the ownership of the table?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to change the ownership of the table?
Дата
Msg-id 12305.980350469@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to change the ownership of the table?  (Ramesh H R <ramesh@easi.soft.net>)
Список pgsql-sql
Ramesh H R <ramesh@easi.soft.net> 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: i have a big trouble
Следующее
От: Michael Davis
Дата:
Сообщение: RE: SQL Query Results