Andrew Dunstan wrote:
>
>
> Tom Lane wrote:
>
> >Or perhaps use a different separator:
> >
> >junk=# select * from xyz;
> > id | name | address | del_addr
> >----+------------+-----------------------------------+----------------------------------
> > 1 | Joe Bloggs | 1 Hindhead Villas, | 2 The Laurels,
> > + + Newport, + Swinkley,
> > + + Gwent + XX3 5CX
> >(1 row)
> >
> >
>
> That's a terrific idea, and, incidentally, just the sort of project that
> might well suit a beginning hacker, since the code is pretty isolated.
>
> >Not sure how hard this would be to program, or what sort of overhead it
> >might impose to check for the case. My recollection is that psql's
> >table-layout code is pretty slow and ugly already ...
> >
> >
> >
> >
>
> If people want speed they shouldn't use psql as a client anyway. I don't
> see this as much of an obstacle.
Added to TODO:
o Allow multi-line column values to align in the proper columns
If the second output column value is 'a\nb', the 'b' should appear
in the second display column, rather than the first column as it
does now.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
