Re: Spacing in output

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, 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;
>                                             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