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

From Tom Lane
Subject Re: Disadvantages to using "text"
Date
Msg-id 8426.1210176567@sss.pgh.pa.us
Whole thread Raw
In response to Disadvantages to using "text"  ("Don Mies (NIM)" <dmies@networksinmotion.com>)
List pgsql-novice
"Don Mies (NIM)" <dmies@networksinmotion.com> writes:
> 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?

No, no, and no.  The only good reason I've heard of to avoid text is
that there are some "database independent" client-side tools that
don't really understand it, and if you're using one of those it's
a problem.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: Disadvantages to using "text"
Next
From: Aurynn Shaw
Date:
Subject: Re: Disadvantages to using "text"