Re: Text type versus Varchar(n)

On Tue, Feb 08, 2005 at 11:09:09PM -0500, Kevin Crenshaw wrote:
>
> I have just set up my first Postgresql database and I was wondering if
> it is more efficient to use the Text data type or the Varchar(n) data
> type.

The FAQ and documentation discuss the similarities and differences
between the character types:

http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.10
http://www.postgresql.org/docs/8.0/static/datatype-character.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/