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@hawaii.rr.com]
Sent: Tuesday, September 14, 2004 2:06 PM
To: pgsql-general@postgresql.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