"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Tue, Mar 29, 2016 at 2:45 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
