From: | "Ewan, Michael" <michael(dot)ewan(at)intel(dot)com> |
---|---|
To: | wes <pdxpug(at)the-wes(dot)com>, Postgresql PDX_Users <pdxpug(at)postgresql(dot)org> |
Subject: | Re: pgadmin display question |
Date: | 2008-12-24 18:42:08 |
Message-ID: | 66C9C47441840949A66773F8F0D9D6A7114E4F86@rrsmsx503.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-01-05 20:28:29 | PgDAY LFNW CFP |
Previous Message | wes | 2008-12-24 18:20:59 | pgadmin display question |