Below is the syntax to rename a table in Postgres where tablename is the current name of the table and new_tablename is the new name.
ALTER TABLE tablename RENAME TO new_tablename;
Below is the syntax to rename a table in Postgres where tablename is the current name of the table and new_tablename is the new name.
ALTER TABLE tablename RENAME TO new_tablename;