> > I was thinking more along the lines of ALTER TABLE a.b RENAME TO x.y
> >
> > I don't see anything in the SQL spec about this; anyone know what
> > precedent is in Oracle or other DBMSes?
>
> Good question. I can't find anything in the Oracle docs indicating it is
even
> possible. We should probably just go with your suggestion. Anything else
> beyond the relnamespace and pg_depend entries that need to be dealt with?
What about sequences for serial columns? What about views or types that
depend on the table?
Chris