View Single Post

   
  #2 (permalink)  
Old 05-07-2008, 07:21 PM
=?UTF-8?Q?Rodrigo_E._De_Le=C3=B3n_Plicet?=
 
Posts: n/a
Default Re: Disadvantages to using "text"

On Wed, May 7, 2008 at 10:52 AM, Don Mies (NIM)
<dmies@networksinmotion.com> wrote:
> 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.)


Reading The Fine Manual reveals all that is asked:
http://www.postgresql.org/docs/8.3/s...character.html

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

Reply With Quote