Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E6C8F47597C for ; Mon, 19 Aug 2002 12:45:31 -0400 (EDT) Received: from helios.geneseo.edu (helios.geneseo.edu [137.238.1.100]) by postgresql.org (Postfix) with ESMTP id 63AB24754A3 for ; Mon, 19 Aug 2002 12:45:31 -0400 (EDT) Received: from mercury.geneseo.edu (mercury.geneseo.edu [137.238.1.101]) by helios.geneseo.edu (8.12.5/8.12.5) with ESMTP id g7JGjaB9028795 for ; Mon, 19 Aug 2002 12:45:36 -0400 (EDT) From: Scott David Walter Received: from geneseo.edu (localhost.localdomain [127.0.0.1]) by mercury.geneseo.edu (8.12.5/8.12.5) with SMTP id g7JGjXm0008121 for ; Mon, 19 Aug 2002 12:45:33 -0400 Received: from dynamo.phor.com ([65.206.3.249]) (SquirrelMail authenticated user sdw1) by webmail.geneseo.edu with HTTP; Mon, 19 Aug 2002 12:45:33 -0400 (EDT) Message-ID: <3329.65.206.3.249.1029775533.squirrel@webmail.geneseo.edu> Date: Mon, 19 Aug 2002 12:45:33 -0400 (EDT) Subject: Modify column type To: X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/272 X-Sequence-Number: 9118 Is there a way to modify the type of an existing column? All I actually want to do is extend the length of the type from a VARCHAR(6) to VARCHAR(100). Column | Type | Modifiers ------------------------+-----------------------+------------------------ email | character varying(6) | not null gold_program=> ALTER TABLE student MODIFY email varchar(100); ERROR: parser: parse error at or near "modify"