Обсуждение: Text type versus Varchar(n)

Поиск
Список
Период
Сортировка

Text type versus Varchar(n)

От
"Kevin Crenshaw"
Дата:

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.

 

Thanks for your help,

 

 

kevin crenshaw

 

Re: Text type versus Varchar(n)

От
Michael Fuhr
Дата:
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/