Postgres Pro
Downloads
Home   >   mailing lists

Re: varchar vs. text - Mailing list pgsql-hackers

From Tom Lane
Subject Re: varchar vs. text
Date
Msg-id 16406.994808279@sss.pgh.pa.us
Whole thread Raw
In response to varchar vs. text  (Rachit Siamwalla <rachit@ensim.com>)
List pgsql-hackers
Tree view 
Rachit Siamwalla <rachit@ensim.com> writes:
> Is there any good reason to use VARCHAR over TEXT for a string field?

The only reason to use VARCHAR is if you *want* the data to be truncated
at a specific length.  If you don't have a well-defined upper limit in
mind, I'd recommend TEXT.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [OT] Any major users of postgresql?
Next
From: Tom Lane
Date:
Subject: Re: SOMAXCONN (was Re: Solaris source code)