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_name FROM Products;
Is prod_name a char(n) for some large n? Cheers, D > 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 -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
