Re: BUG #16743: psql doesn't show whole expression in stored column - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16743: psql doesn't show whole expression in stored column
Date
Msg-id 286182.1606232817@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16743: psql doesn't show whole expression in stored column  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16743: psql doesn't show whole expression in stored column
Re: BUG #16743: psql doesn't show whole expression in stored column
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.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



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16743: psql doesn't show whole expression in stored column
Next
From: Manoj Kumar
Date:
Subject: Re: BUG #16739: Temporary files not deleting from data folder on disk