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.