Question #200

Author: admin
tags: PostgreSQL   backend  
How to rename a table in PostgreSQL?
RENAME TABLE people TO users;
UPDATE TABLE people SET name = 'users';
ALTER TABLE people RENAME TO users;
Alas, an existing table cannot be renamed
Rate the difficulty of the question:
easyhard