Re: Question about varchar and text

From: Thomas Braad Toft <pgsql-general(at)magicx(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about varchar and text
Date: 2005-01-06 18:10:43
Message-ID: 41DD7F23.7020101@magicx.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

Stewart, Robert D (COT) wrote:

> What is the difference between varchar and text?
>
> I have heard that you can use text instead of varchar and this could
speed up your tables.

http://www.postgresql.org/docs/7.4/interactive/datatype-character.html

Quote: "Tip: There are no performance differences between these three
types, apart from the increased storage size when using the blank-padded
type."

--
Thomas Braad Toft

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-01-06 18:25:10 Re: Question about varchar and text
Previous Message vhikida 2005-01-06 18:09:06 Re: Query, view join question.