Wouldn't ALTER [OBJECT] RENAME TO [schema.][name]
be a better? After all, this is essentially a rename operation, so maybe it is better to extend existing syntax... 5WD-02-Foundation-2003-09.pdf doesn't seem to specify any renaming with ALTER TABLE... ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org