Re: Question about varchar and text - Mailing list pgsql-general

From Thomas Braad Toft
Subject Re: Question about varchar and text
Date
Msg-id 41DD7F23.7020101@magicx.dk
Whole thread Raw
In response to Question about varchar and text  ("Stewart, Robert D (COT)" <RobertD.Stewart@ky.gov>)
List 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

pgsql-general by date:

Previous
From: vhikida@inreach.com
Date:
Subject: Re: Query, view join question.
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Question about varchar and text