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 whole 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.)







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-2015 The PostgreSQL Global Development Group