Postgres Pro
Downloads
Home   >   mailing lists

varchar vs. text - Mailing list pgsql-general

From Michael Garriss
Subject varchar vs. text
Date
Msg-id 3F692DB0.4010300@earthlink.net
Whole thread Raw
Responses Re: varchar vs. text  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: varchar vs. text  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
I curious about the benefits of a varchar over text.  Is it speed,
size?  If so, how much speed, size?  Is a varchar(64) and a text with 64
chars the same size?  I'm inclined to make all my varchars into text so
I don't have to worry about inserting something to big.

TIA,
Michael

pgsql-general by date:

Previous
From: "Robert Wille"
Date:
Subject: Re: Sort order is different on Windows and Linux
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] backend crashing despite tsearch2 patch