Re: Renaming tables

On Mon, 11 Mar 2002, Tim DeMarco wrote:


>  I have several tables I am planning on renaming and ran into a little
> trouble.  I know I can fix the problem, but I'm hoping there is an
> easier solution.  Here is an example:  I rename usergroupstatus to
> usergroupstatusvalues.  I did a dump of the this table as well as a
> table that has a Fkey to this table:
>
>  The constraints still refer to the original table name
> (usergroupstatus).  I know that I can drop and re-create the tables
> and have them refer to the new table, but I'm hoping there is a better
> way.  Also, if I need to recreate the tables should I use the
> statements above (generated by pg_dump) and manually modify the
> constraints?

It might be easier to drop the triggers and use alter table to add the
foreign key constraints again.