Re: Disadvantages to using "text" - Mailing list pgsql-novice

From Rodrigo E. De León Plicet
Subject Re: Disadvantages to using "text"
Date
Msg-id a55915760805070901t7223f9f0r92404b1b1dbe475@mail.gmail.com
Whole thread Raw
In response to Disadvantages to using "text"  ("Don Mies (NIM)" <dmies@networksinmotion.com>)
List pgsql-novice
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/static/datatype-character.html

pgsql-novice by date:

Previous
From: "Don Mies (NIM)"
Date:
Subject: Disadvantages to using "text"
Next
From: "Richard Broersma"
Date:
Subject: Re: Disadvantages to using "text"