>>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