"David G. Johnston" <[email protected]> writes:
> On Tue, Mar 29, 2016 at 2:45 PM, Tom Lane <[email protected]> wrote:
>> It's not really different. What you're seeing is pg_dump (or actually
>> ruleutils.c) choosing to dump some implicit casts explicitly to ensure
>> that the expression is parsed the same way next time.
> âWhy don't we just use ruleutils.c to generate \d results so that what we
> end up showing is canonical?
We do. AFAIK, what psql's \d shows in these cases is the same as what
pg_dump will print. Joshua's complaint is that it isn't necessarily
identical to what was input.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general