"David G. Johnston" <david.g.johns...@gmail.com> writes:
> On Tue, Mar 29, 2016 at 2:45 PM, Tom Lane <t...@sss.pgh.pa.us> 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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
