X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E0637D1B379 for ; Mon, 26 Jul 2004 19:39:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60905-04 for ; Mon, 26 Jul 2004 22:39:12 +0000 (GMT) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id C7BAED1B266 for ; Mon, 26 Jul 2004 19:39:05 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id B2EEA350C7; Mon, 26 Jul 2004 19:39:08 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id AF9853456A for ; Mon, 26 Jul 2004 19:39:08 -0300 (ADT) X-Return-Path: X-Received: from localhost ([unix socket]) by ganymede.hub.org (Cyrus v2.2.6) with LMTPA; Mon, 26 Jul 2004 14:47:10 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 68C6938161 for ; Mon, 26 Jul 2004 14:46:14 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5) for scrappy@localhost (single-drop); Mon, 26 Jul 2004 14:46:14 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.6) with LMTPA; Mon, 26 Jul 2004 14:42:51 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ABBACD1B392 for ; Mon, 26 Jul 2004 14:42:51 -0300 (ADT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15707-04 for ; Mon, 26 Jul 2004 17:42:50 +0000 (GMT) X-Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 76CE9D1B731 for ; Mon, 26 Jul 2004 14:42:48 -0300 (ADT) thread-index: AcRzOCcKW5qLhkwyQCydmw3ouJ3TIA== Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 X-Received: from [10.4.2.203] ([66.194.26.150]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.0); Mon, 26 Jul 2004 13:44:07 -0400 Message-ID: <4105440C.2090108@sermonaudio.com> Date: Mon, 26 Jul 2004 13:49:00 -0400 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 0.6 (X11/20040711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Subject: Max varchar size Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 26 Jul 2004 17:44:07.0966 (UTC) FILETIME=[26CEB3E0:01C47338] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-DCC: : X-Spam-Pyzor: ReSent-Date: Mon, 26 Jul 2004 19:39:04 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-admin@postgresql.org ReSent-Subject: Max varchar size ReSent-Message-ID: <20040726193904.Y68882@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/300 X-Sequence-Number: 14368 I need to know what the max size of a varchar field is allowed to be in 7.3.4. I have a table that someone created with a varchar(1000) field (before I started here). We are noticing that when we try to view that field we only end up with ~255 characters. This is making me think that varchars are limited to 255. Is this true? If it is not, how do I see the rest of the field? If it is, is the rest of the field lost? Thanks, Chris