Postgres Pro
Downloads
Home   >   mailing lists

Re: varchar(n) VS text - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: varchar(n) VS text
Date
Msg-id 20070628010742.GC561@alvh.no-ip.org
Whole thread Raw
In response to Re: varchar(n) VS text  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List pgsql-general
Tree view 
Paul Lambert wrote:

> Is there any disk space advantages to using varchar over text?  Or will a
> text field only ever use up as much data as it needs.

1. no 2. yes.

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"Hackers share the surgeon's secret pleasure in poking about in gross innards,
the teenager's secret pleasure in popping zits."                 (Paul Graham)

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: varchar(n) VS text
Next
From: Paul Lambert
Date:
Subject: Re: varchar(n) VS text