Re: Spacing in output - Mailing list pgsql-general

From Jerome Lyles
Subject Re: Spacing in output
Date
Msg-id 200409151815.11773.susemail@hawaii.rr.com
Whole thread Raw
In response to Re: Spacing in output  (David Fetter <david@fetter.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: what is flushed?
Next
From: "alexandre:"@smtp2.netsite.com.br:aldeia digital
Date:
Subject: pg_locks with users