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: (view raw, whole thread or download thread mbox)
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.


In response to

pdxpug by date

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

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