Re: [sqlite] sqlite3 column widths

Hi TIm, sqlite3 already includes the ability to define the width manually with the .width command. I was hoping that there might be a way to use the defined string length as part of the default when .width is not used. Pete On Thu, Apr 26, 2012 at 9:00 AM,

Re: [sqlite] sqlite3 column widths

On 25 Apr 2012 at 17:36, Pete wrote: > So I guess that's a "No" then? > > I'm fully aware of how sqlite3 treats datatypes and column width > specifications, but surely if someone defines a column with a specific max > width, it's reasonable to assume that's the max width

Re: [sqlite] sqlite3 column widths

eral Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] sqlite3 column widths > Message-ID: <4f97106d.7080...@rogerbinns.com> > Content-Type: text/plain; charset=ISO-8859-1 > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > O

Re: [sqlite] sqlite3 column widths

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 24/04/12 13:26, Pete wrote: > Is there way to have sqlite3 display the columns in the result of a > SELECT statement using their defined widths in the schema? For example > if a column is defined as "Name(40) TEXT", I want the column to be 40 >