Thread: refactoring: changing tables names

refactoring: changing tables names

From
Ivan Sergio Borgonovo
Date:
I need to change some table names, substitute some with views and
duplicate others.

As a first experiment I was planning to create a view that clone a
table and then rename the occurrences of the table name with the
view where needed finally change the definition of the view.

Am I going to incur in any significant slowdown accessing the table
indirectly?

Later I'll have to rename tables that have associated sequences,
pk/fk and are referenced in functions etc... etc...

Any good list of advices?

Is there any tools that works with postgresql that can help me?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it