Re: [ADMIN] varchar vs text columns
Andrew Sullivan wrote: On Mon, Jul 23, 2007 at 11:33:54AM -0700, Jessica Richard wrote: What is the difference between varchar and text for a string column? What is the benefit of using each one? Is text better than varchar performance wise? From the manual: Tip: There are no performance differences between these three types, apart from the increased storage size when using the blank-padded type. While character(n) has performance advantages in some other database systems, it has no such advantages in PostgreSQL. In most situations text or character varying should be used instead. Note that varchar(n) will have a performance effect, because on insert or update you have to check to make sure the input doesn't exceed the specified length. See also Peter Koczan's reply in the '_ in a serach pattern' thread. -- Lew ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] varchar vs text columns
On Mon, Jul 23, 2007 at 11:33:54AM -0700, Jessica Richard wrote: What is the difference between varchar and text for a string column? What is the benefit of using each one? Is text better than varchar performance wise? From the manual: Tip: There are no performance differences between these three types, apart from the increased storage size when using the blank-padded type. While character(n) has performance advantages in some other database systems, it has no such advantages in PostgreSQL. In most situations text or character varying should be used instead. Note that varchar(n) will have a performance effect, because on insert or update you have to check to make sure the input doesn't exceed the specified length. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [ADMIN] varchar vs text columns
Jessica Richard wrote: What is the difference between varchar and text for a string column? Nothing, if you don't use a limit for varchar. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
