Re: BUG #16743: psql doesn't show whole expression in stored column

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: turon(dot)david(at)seznam(dot)cz
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16743: psql doesn't show whole expression in stored column
Date: 2020-11-24 15:46:57
Message-ID: 286182.1606232817@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> when generated column expression length is larger then some value - the rest
> of expression is cut in \d[+] output:

Yeah, this is an intentional and very ancient behavior:

appendPQExpBufferStr(&buf,
",\n (SELECT substring(pg_catalog.pg_get_expr(d.adbin, d.adrelid, true) for 128)"
"\n FROM pg_catalog.pg_attrdef d"

Maybe we should decide that completeness is more important than keeping
the line to some arbitrary width. But it's operating as designed.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Manoj Kumar 2020-11-24 15:47:38 Re: BUG #16739: Temporary files not deleting from data folder on disk
Previous Message PG Bug reporting form 2020-11-24 14:17:09 BUG #16743: psql doesn't show whole expression in stored column