X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B6915D1CADC for ; Wed, 10 Mar 2004 16:58:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52117-06 for ; Wed, 10 Mar 2004 12:58:15 -0400 (AST) Received: from mx5.kent.ac.uk (mx5.ukc.ac.uk [129.12.21.36]) by svr1.postgresql.org (Postfix) with ESMTP id 53B53D1CA3E for ; Wed, 10 Mar 2004 12:58:12 -0400 (AST) Received: from pelican.ukc.ac.uk ([129.12.200.26]) by mx5.kent.ac.uk with esmtp (Exim 4.24) id 1B171z-0007m4-2B for pgsql-sql@postgresql.org; Wed, 10 Mar 2004 16:58:07 +0000 Received: from dhcp6642.ukc.ac.uk ([129.12.102.66] helo=PC2LP051) by pelican.ukc.ac.uk with smtp (Exim 4.22) id 1B171w-00039j-8T for pgsql-sql@postgresql.org; Wed, 10 Mar 2004 16:58:04 +0000 Message-ID: <006801c406c0$da8fef50$42660c81@ad.kent.ac.uk> From: "David" To: References: <403F762B.20002@aol.net> <20773.1077905537@sss.pgh.pa.us> <008901c4069c$ba6591e0$49660c81@ad.kent.ac.uk> <200403101351.51800.dev@archonet.com> Subject: Alter table Date: Wed, 10 Mar 2004 16:58:04 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-UKC-Mail-System: No virus detected X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/108 X-Sequence-Number: 17207 Ok another very newbie question. How can i change the data type a column can accept? at the moment it will only take character(7) i want to change it to varchar(30), but i cant figure how, ideas? Many thanks Dave