rename_view¶

The rename_view command allows you to change the name of an epsio view. After the change, the view can only be referenced with the new name.

Syntax¶

CALL epsio.rename_view(<old_view_name>, <new_view_name>);

Parameter	Information
old_view_name	The name of the view to be changed.
new_view_name	The new name for the view.

Renaming a view named countries_population:

CALL epsio.rename_view('countries_population', 'old_countries_population');

Renaming views in a transaction in order to perform a "hot swap":

begin;
CALL epsio.drop_view('countries_population');
CALL epsio.rename_view('new_countries_population_view', 'countries_population');
commit;