Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A6BB79FB2B4 for ; Mon, 23 Jul 2007 15:34:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 21086-10 for ; Mon, 23 Jul 2007 15:33:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56408.mail.re3.yahoo.com (web56408.mail.re3.yahoo.com [216.252.111.87]) by postgresql.org (Postfix) with SMTP id 4466D9FA4A3 for ; Mon, 23 Jul 2007 15:33:55 -0300 (ADT) Received: (qmail 84998 invoked by uid 60001); 23 Jul 2007 18:33:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=usENlsU7vSSgAN0BrTzu7rM/Z07KMDyc3q3zTFxHOAaGr1GJFT3LIEo9yKc6YiL2zA3RTx0AD4INvzDb5hUKyjE+aap/pobSdUHGKI7K0eL/lhm0bQ6MaXw6glMqogTd/rPF+qVnTIYB/7bqqv3R7oIo3Y9xris4YcE/rZ+1r4E=; X-YMail-OSG: ir2F7JoVM1leNPtuvczrHdwqqNWjMayTQDSbYVbvVp3NcfHnpvpPEKQVHfQYgy00Lmz5ZgfoCNURcGQ40WTCjvtuCF.SW.017L2l6FJ9a1NbvoRS4cGQ3ZfCCWg5Vrs- Received: from [198.119.134.32] by web56408.mail.re3.yahoo.com via HTTP; Mon, 23 Jul 2007 11:33:54 PDT Date: Mon, 23 Jul 2007 11:33:54 -0700 (PDT) From: Jessica Richard Subject: varchar vs text columns To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-438413896-1185215634=:84815" Content-Transfer-Encoding: 8bit Message-ID: <835361.84815.qm@web56408.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.242 tagged_above=0 required=5 tests=AWL=0.426, BAYES_40=-0.185, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200707/249 X-Sequence-Number: 26230 --0-438413896-1185215634=:84815 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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? Thanks. --------------------------------- Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. --0-438413896-1185215634=:84815 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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?

Thanks.


Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center. --0-438413896-1185215634=:84815--