diff b/w varchar(N) & text

From: sathiya psql <sathiya(dot)psql(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: diff b/w varchar(N) & text
Date: 2009-03-17 11:02:09
Message-ID: f966c2ee0903170402o18423f43jc2ea86da6e8decd5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi.,

Is there any big difference between selecting the data type as varchar(N)
and text. What is the difference of it when seeing from the performance side
?

I know that, when we know that the number of character will not exceed N, we
can use the varchar as datatype. If we dont know we can use this text as
datatype. But other than this anyother difference is there, and particularly
in performance, and also if the number of rows crosses 100 thousand... Any
other views ?

Any advise on this is appreciated.

Thanks & Regards
SathiyaMoorthy.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message sathiya psql 2009-03-17 11:04:16 Re: Exclude fields from SELECT command
Previous Message Gianvito Pio 2009-03-17 06:39:48 Methods declaration