The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Renaming a View

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!

Comments

  • can we rename database?

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    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.

Sign In or Register to comment.