How to Rename a Table in PostgreSQL

This example renames the table my_table to my_renamed_table:

ALTER TABLE my_table RENAME TO my_renamed_table;
Previous
How to Drop a Table in PostgreSQL
Next
How to Add a Column in PostgreSQL

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.

Download Learn more