X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 3D9BA924EAD for ; Tue, 27 May 2003 12:37:21 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 23576-09 for ; Tue, 27 May 2003 12:37:16 -0400 (EDT) Received: from tomts17-srv.bellnexxia.net (tomts17.bellnexxia.net [209.226.175.71]) by developer.postgresql.org (Postfix) with ESMTP id A25F4924E90 for ; Tue, 27 May 2003 12:37:15 -0400 (EDT) Received: from acer.sympatico.ca ([65.93.64.54]) by tomts17-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030527152249.KCAY24521.tomts17-srv.bellnexxia.net@acer.sympatico.ca> for ; Tue, 27 May 2003 11:22:49 -0400 Message-Id: <5.2.0.9.0.20030527111114.037fd930@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Tue, 27 May 2003 11:17:20 -0400 To: From: Frank Bax Subject: Re: alter column witdh In-Reply-To: <016901c3245d$b1a820d0$0701a8c0@netterm> References: <001101c31fb8$ebdb30c0$0701a8c0@netterm> <3ECE195A.7060209@Yahoo.com> <004901c3212e$8919fda0$0701a8c0@netterm> <3ECFE017.7060800@Yahoo.com> <00e001c32453$2f8f45b0$0701a8c0@netterm> <15000.1054045212@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/519 X-Sequence-Number: 13684 At 10:38 AM 5/27/03, Eric Anderson Vianet SAO wrote: >how can I alter the column width http://techdocs.postgresql.org/techdocs/updatingcolumns.php fbax=# create table tablename (columnname text); CREATE fbax=# \d tablename Table "tablename" Attribute | Type | Modifier ------------+------+---------- columnname | text | fbax=# \q pg_dump -o -c -s -t tablename fbax | sed "s:\"columnname\" text:\"columnname\" varchar(2):" | psql Frank