Re: pgadmin display question

["Ewan, Michael" <michael(dot)ewan(at)intel(dot)com>]

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.

-wes