Thread: 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
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
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
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@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
On Tuesday 14 September 2004 11:15 am, you wrote: > 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 fieldsize: 255. I tried to use SUBSTR: sql_tutorial=> SUBSTR(prod_name,1,45; SELECT prod_name FROM Products; sql_tutorial(> sql_tutorial(> sql_tutorial(> SELECT prod_name FROM Products; sql_tutorial(> SUBSTR(prod_name,1,45; but I have the syntax wrong. What does '(>' instead of '=>' mean? Thanks, Jerome
Do this:
SELECT SUBSTR(prod_name,1,45) from Products;
Duane
-----Original Message-----
From: Jerome Lyles [mailto:susemail@hawaii.rr.com]
Sent: Tuesday, September 14, 2004 4:22 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Spacing in output
On Tuesday 14 September 2004 11:15 am, you wrote:
> 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
fieldsize: 255. I tried to use SUBSTR:
sql_tutorial=> SUBSTR(prod_name,1,45; SELECT prod_name FROM Products;
sql_tutorial(>
sql_tutorial(>
sql_tutorial(> SELECT prod_name FROM Products;
sql_tutorial(> SUBSTR(prod_name,1,45;
but I have the syntax wrong. What does '(>' instead of '=>' mean?
Thanks,
Jerome
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
On Tue, Sep 14, 2004 at 01:21:48PM -1000, Jerome Lyles wrote: > On Tuesday 14 September 2004 11:15 am, you wrote: > > 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 > fieldsize: 255. I tried to use SUBSTR: > > sql_tutorial=> SUBSTR(prod_name,1,45; SELECT prod_name FROM Products; > sql_tutorial(> > sql_tutorial(> > sql_tutorial(> SELECT prod_name FROM Products; > sql_tutorial(> SUBSTR(prod_name,1,45; > > but I have the syntax wrong. What does '(>' instead of '=>' mean? That means you havn't closed the opening bracket on the first line. Every open bracket must be matched by a closing one... -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment
On Tuesday 14 September 2004 11:27 am, David Fetter wrote: > 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 char(255) Jerome
On Tue, Sep 14, 2004 at 06:37:40PM -1000, Jerome Lyles wrote: > On Tuesday 14 September 2004 11:27 am, David Fetter wrote: > > 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 > char(255) Well, Don't Do That, Then. TEXT is a great type for storing text. VARCHAR(n) is a TEXT with a maximum length constraint, and CHAR(n) (fixed length) is pretty nearly obsolete. Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote!
On Wednesday 15 September 2004 05:24 am, David Fetter wrote: > On Tue, Sep 14, 2004 at 06:37:40PM -1000, Jerome Lyles wrote: > > On Tuesday 14 September 2004 11:27 am, David Fetter wrote: > > > 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 > > > > char(255) > > Well, Don't Do That, Then. TEXT is a great type for storing text. > VARCHAR(n) is a TEXT with a maximum length constraint, and CHAR(n) > (fixed length) is pretty nearly obsolete. > > Cheers, > D This is amazing. Im using a book called 'Teach Yourself SQL in 10 minutes' with a 2004 copyright and this is the second example of obsolete TEXT type used in the examples so far. Jerome
On Tuesday 14 September 2004 01:31 pm, Duane Lee - EGOVX wrote:
> Do this:
>
>
> SELECT SUBSTR(prod_name,1,45) from Products;
>
>
> Duane
I did:
sql_tutorial=> SELECT SUBSTR(prod_name,1,45) from Products;
substr
---------------------
8 inch teddy bear
12 inch teddy bear
18 inch teddy bear
Fish bean bag toy
Bird bean bag toy
Rabbit bean bag toy
Raggedy Ann
King doll
Queen doll
(9 rows)
Thanks,
Jerome
susemail@hawaii.rr.com (Jerome Lyles) wrote in news:200409141105.46091.susemail@hawaii.rr.com: > 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: the simplest is SELECT prod_name::text FROM products; (will cast the char(255) column to text and in the process removes all trailing spaces.) or use trim function to remove trailing spaces. -- Rolf