Re: Spacing in 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_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 david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!