Move Table to new Owner and Schema

I had to rename and move a table in a new schema and assign a new role.

alter table vr.ax_control rename to lr_control;
alter table vr.lr_control set schema fabrik;
alter table fabrik.lr_control owner to fabrik;

\dt fabrik.*
                          List of relations
   Schema    |            Name             | Type  |    Owner    
-------------+-----------------------------+-------+-------------
 fabrik      | lr_control                  | table | fabrik

Change Content

The information on this page is user generated content. The content does not claim to be complete or correct.

Everybody is invited to add or change the data. Just click on this link. No login or email is required. Thanks.