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

Disadvantages to using "text"

From: "Don Mies (NIM)" <dmies(at)networksinmotion(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Disadvantages to using "text"
Date: 2008-05-07 15:52:27
Message-ID: 3329C5B4110B6F429B69A8D70AC74D0303A9B544@exchange1.NIMONE.COM (view raw or flat)
Thread:
Lists: pgsql-novice
Are there any reasons for not using the "text" type whenever a variable
length string field is needed?  Are there penalties in disk usage,
memory usage or performance?

 

What are the differences between declaring something "varchar" or
"varchar(n)" or "text"?  (I realize that the middle one has an upper
limit while the others do not.)

 

 

Don

 

 

Responses

pgsql-novice by date

Next:From: Rodrigo E. De León PlicetDate: 2008-05-07 16:01:09
Subject: Re: Disadvantages to using "text"
Previous:From: Bruce MomjianDate: 2008-05-07 15:47:50
Subject: Re: [NOVICE] encoding problems

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