refactoring: changing tables names

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: refactoring: changing tables names
Date: 2009-01-09 23:29:30
Message-ID: 20090110002930.45304e71@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2009-01-09 23:37:11 Re: Improving compressibility of WAL files
Previous Message Kevin Grittner 2009-01-09 21:31:20 Re: Improving compressibility of WAL files