Since when was that a design goal for psql's \d output? We had better revert the entire pretty-printing patch if you expect this sort of thing to work reliably. I thought the point of \d formatting was to be readable, not to be technically the exact same SQL you'd need to enter.
Hm, I always assumed it would work. It always did modulo quoting issues around $n.
It's certainly inconvenient if it doesn't given that there's no supported way to disable a particular constraint and then reenable it later without having the source available.
One thing that would be nice about using fmtId in psql is that names that DON'T need to be quoted would not be quoted.
Chris
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
