It turns out that it is possibly to simply move a table from one schema to another:
```sql
-- move meters table from platform_v1 to platform_v2
alter table platform_v1.meters
set schema platform_v2;
```
There's no need to update views that depends on the renamed table.
#postgresql