Skip site navigation (1) Skip section navigation (2)

Re: Field Size

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Somasekhar Bangalore <sbangalore(at)zensutra(dot)com>
Cc: Ganesan Kanavathy <ganesh(at)magnusquest(dot)com>,pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Field Size
Date: 2003-12-08 15:35:52
Message-ID: 20031208153552.GA5971@wolff.to (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
On Mon, Dec 08, 2003 at 18:36:57 +0530,
  Somasekhar Bangalore <sbangalore(at)zensutra(dot)com> wrote:
> There is no harm in having a field size of 1000 character provided u use the proper datatype. Don't user char(1000). Try using varchar(1000).

And if the 1000 limit is just a large number you picked rather than a
real rule for your data, then you probably want to use the TEXT type.

In response to

pgsql-admin by date

Next:From: Robert TreatDate: 2003-12-08 21:15:50
Subject: Re: Auto commit Off how will it effect us ?
Previous:From: Andrei BintintanDate: 2003-12-08 14:30:19
Subject: Re: timestamp field

pgsql-sql by date

Next:From: violaDate: 2003-12-08 23:23:07
Subject: postgresql and ColdFusion
Previous:From: Somasekhar BangaloreDate: 2003-12-08 13:06:57
Subject: Re: Field Size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group