Re: Text type versus Varchar(n) - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Text type versus Varchar(n)
Date
Msg-id 20050209074017.GB88890@winnie.fuhr.org
Whole thread Raw
In response to Text type versus Varchar(n)  ("Kevin Crenshaw" <kcrenshaw@tiewireinc.com>)
List pgsql-novice
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/

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: table name as function argument?
Next
From: "Rajan Bhide"
Date:
Subject: Finding column using SQL query.