Renaming a View

[Deleted User]

You are probably aware that you can rename a table using the ALTER TABLE … RENAME command.

Example:

dbadmin=> \dt test
              List of tables
Schema | Name | Kind  |  Owner  | Comment
--------+------+-------+---------+---------
public | test | table | dbadmin |
(1 row)

dbadmin=> ALTER TABLE test RENAME TO test_new;
ALTER TABLE

But you might not know that you can just as easily rename a database view using a very similar command!

Example:

dbadmin=> \dv test_view;
            List of View Fields
Schema |   View    | Column | Type | Size
--------+-----------+--------+------+------
public | test_view | c1     | int  |    8
(1 row)

dbadmin=> ALTER VIEW test_view RENAME TO test_view_new;
ALTER VIEW

Have fun!

sreedxc

can we rename database?

Jim_Knicely

Not easily! That is, there is not a simple SQL DDL command to rename a database...

dbadmin=> SELECT database_name FROM databases;
 database_name
---------------
 test_db
(1 row)

dbadmin=> ALTER DATABASE test_db RENAME TO test_db_new;
ERROR 2676:  Command ALTER DATABASE is not supported

But there is a way to rename a database. You'll need to open a support ticket for that. Most of the time it's just easier to create a new database and re-load it.