Re: VARCHAR AND TEXT DATA TYPES

From: ries van Twisk <pg(at)rvt(dot)dds(dot)nl>
To: "JORGE MALDONADO" <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: VARCHAR AND TEXT DATA TYPES
Date: 2009-01-05 23:35:58
Message-ID: B56A6D80-9E6E-4812-8E9E-EAA2FFF07D33@rvt.dds.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Jan 5, 2009, at 5:44 PM, JORGE MALDONADO wrote:

> If I need a field of type character without size limit, should I use
> VARCHAR specifying no length or TEXT?
> What would be the difference?

Use Text, internally there is no difference between varchar and text
except that varchar has a added contraint with lenght.

>
> With respect,
> Jorge Maldonado

Ries

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nagle, Gail A (US SSA) 2009-01-06 00:32:29 Character Set UTF8 and libpq
Previous Message JORGE MALDONADO 2009-01-05 22:44:16 VARCHAR AND TEXT DATA TYPES