My Database Friend PostgreSQL

Next: Upgrading PostgreSQL Version 9.6 to PostgreSQL 10 on FreeBSD 11.0 UP: TOC

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
Next: Upgrading PostgreSQL Version 9.6 to PostgreSQL 10 on FreeBSD 11.0 UP: TOC