On Tue, Sep 14, 2004 at 06:37:40PM -1000, Jerome Lyles wrote:
> On Tuesday 14 September 2004 11:27 am, David Fetter wrote:
> > On Tue, Sep 14, 2004 at 11:05:46AM -1000, Jerome Lyles wrote:
> > > I have a small training database: sql_tutorial. It works fine
> > > but the spacing between the output
On Tue, Sep 14, 2004 at 11:05:46AM -1000, Jerome Lyles wrote:
> I have a small training database: sql_tutorial. It works fine but the spacing
> between the output lines is too much. This is the way it looks when I copy
> and paste from the Konsole to this email:
>
> sql_tutorial=> SELECT prod_
Title: RE: [GENERAL] Spacing in output
What is the field size of prod_name? You could use SUBSTR(prod_name,1,xx) where xx is the max number of characters you want to see.
Duane
-Original Message-
From: Jerome Lyles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 14, 2004 2:06
The spacing in Konsole is directly related to the wrapping that it's
doing based on the size of the prod_name field (I.e., length in terms
of characters).
You can alter the format settings of psql. See:
http://www.postgresql.org/docs/7.4/static/app-psql.html
-tfo
On Sep 14, 2004, at 4:05 PM, J
I have a small training database: sql_tutorial. It works fine but the spacing
between the output lines is too much. This is the way it looks when I copy
and paste from the Konsole to this email:
sql_tutorial=> SELECT prod_name FROM Products;
prod_nam
