I'm not familiar with pgAdmin specifically, but just looking at the SQL, you could use RPAD(field,length,' ') where length is the size of the column, or use SUBSTRING.
From: pdxpug-owner(at)postgresql(dot)org [mailto:pdxpug-owner(at)postgresql(dot)org] On Behalf Of wes
Sent: Wednesday, December 24, 2008 10:21 AM
To: Postgresql PDX_Users
Subject: [pdxpug] pgadmin display question
I realize this is not the Portland pgAdmin User Group mailing list, but I thought someone here might know this one off the top of their head.
I would like to have the output of a query formatted so that the columns are as wide as the data in the rows. Does anyone know how I can do that?
There are a lot of options in pgAdmin's query window, but they seem to relate to the query itself, rather than the results display.
thanks for any insight.
In response to
pdxpug by date
|Next:||From: Joshua D. Drake||Date: 2009-01-05 20:28:29|
|Subject: PgDAY LFNW CFP|
|Previous:||From: wes||Date: 2008-12-24 18:20:59|
|Subject: pgadmin display question|