Skip site navigation (1) Skip section navigation (2)

Re: pgadmin display question

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 (view raw or flat)
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

In response to

pdxpug by date

Next:From: Joshua D. DrakeDate: 2009-01-05 20:28:29
Subject: PgDAY LFNW CFP
Previous:From: wesDate: 2008-12-24 18:20:59
Subject: pgadmin display question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group