Re: 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:susemail(at)hawaii(dot)rr(dot)com]
Sent: Tuesday, September 14, 2004 2:06 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Spacing in output

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_name
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----------------------------
8 inch teddy bear
12 inch teddy bear
18 inch teddy bear

This is the way it looks on the Konsole:

sql_tutorial=> SELECT prod_name FROM Products;

prod_name
----------------------------------------------------------------------------
----------
----------------------------------------------------------------------------
----------
----------------------------------------------------------------------------
----------
------------------
8 inch teddy bear

12 inch teddy bear

18 inch teddy bear

How can I change the Konsole output to look like the first example?
Thanks,
Jerome

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend