Move Table to new Owner and Schema

2019-05-13 15:22:15.231318+00

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

Tag: postgresql