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

From Joshua D. Drake
Subject Re: text vs. varchar
Date
Msg-id 1279728261.22360.0.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to text vs. varchar  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
On Wed, 2010-07-21 at 08:58 -0700, Ben Chobot wrote:
> Is there any difference between "text" and "varchar" data types? (Not varchar(n), just varchar.) I can't see a
differentfrom the manual page, but I'm wondering about index usage or something similarly subtle. 

They are the same thing. So is varchar(n) it just has a length
constraint.

JD

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering


pgsql-general by date:

Previous
From: Howard Rogers
Date:
Subject: Re: Bitmask trickiness
Next
From: Craig Ringer
Date:
Subject: Re: pg_dump-restore concurrency