2013/5/18 Brian Sherwood <[email protected]>: > I am running postgresql 9.2. > > I am assuming it would be a function of psql to right justify text, but I > can't find any way to do this. > > Is there a way to right justify just one text column?
If you mean have the psql client right-justify a particular text column, no I don't think there's a way to do that. Assuming the column contains single-width characters with no line breaks, you could do something with LPAD along these lines: SELECT LPAD(txtcol, (SELECT MAX(LENGTH(txtcol)) FROM tbl)) FROM tbl HTH Ian Barwick -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
