Modify column type

From: Scott David Walter <sdw1(at)geneseo(dot)edu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Modify column type
Date: 2002-08-19 16:45:33
Message-ID: 3329.65.206.3.249.1029775533.squirrel@webmail.geneseo.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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"

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-08-19 16:45:50 Re: sql subqueries problem
Previous Message Mathieu Arnold 2002-08-19 16:15:10 sql subqueries problem