Jim C. Nasby wrote:
>
> BEGIN;
> -- Don't do the drop right now, because it might take awhile
> ALTER TABLE tablename RENAME TO delete_tablename;
> ALTER TABLE temporary_tablename RENAME TO tablename;
> COMMIT;
> DROP delete_tablename;
>
>
What if there are dependencies? Might be better to have a view, which
everything depends on, and change the view definition from one table to
another back and forth.
cheers
andrew
