Re: Text type versus Varchar(n)

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Kevin Crenshaw <kcrenshaw(at)tiewireinc(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Text type versus Varchar(n)
Date: 2005-02-09 07:40:17
Message-ID: 20050209074017.GB88890@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rajan Bhide 2005-02-09 09:56:20 Finding column using SQL query.
Previous Message John DeSoi 2005-02-09 06:55:51 Re: table name as function argument?