High angle view of Beijing Guomao.
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!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
