varchar allows you to define an explicit length of the field, text does not.
varchar with a length specified (varchar(n)) is sql92 compliant while
varchar() and text are pgsql extensions.
On 2010-07-21 08:58:54AM -0700, Ben Chobot wrote:
> Is there any difference between "text" and "varchar" data types? (Not varchar(n), just varchar.) I can't see a
differentfrom the manual page, but I'm wondering about index usage or something similarly subtle.
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
===========================================================
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===========================================================