How do you do this? I guess it may require heroic methods such as the editing of dumps. Or it is easy?
I'd like to do this because the \d is complicated. I've prototyped this thing in a temp database and now I'd like to do it for real. I'd rather not copy it down on paper and do it all again.
It is okay to move the relation and its data, but I really just want to recreate it in another database.
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend