Received: from matrix.gatewaynet.com (unknown [217.19.69.50])
	by postgresql.org (Postfix) with ESMTP id 4B9EE474E44
	for <pgsql-sql@postgresql.org>; Fri, 26 Jul 2002 08:48:32 -0400 (EDT)
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g6QCngw07439;
	Fri, 26 Jul 2002 15:49:42 +0300
Date: Fri, 26 Jul 2002 15:49:41 +0300 (EEST)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: ROUWEZ Stephane <stephane.rouwez@ecolo.be>
Cc: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>,
	LESNE Philippe <philippe.lesne@ecolo.be>
Subject: Re: Change size of a field
In-Reply-To: <8126A160E6D1D1119AFF00A0CC5C8B0F01228E7C@FEDERAL>
Message-ID: <Pine.LNX.4.44.0207261546030.7428-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200207/412
X-Sequence-Number: 8790

On Fri, 26 Jul 2002, ROUWEZ Stephane wrote:

> Hi,
> 
> Is it possible to change the size of a field ?
> Actually, I have a field called 'nom' in varchar(50) and I want this field
> in varchar(80). 
> I can't do it with PgAdmin. Is it normal ?

Pretty normal!
just 
1) % pg_dump -t <tablename> <dbname> > <tablename>-DUMP.sql
2) % psql
   # drop sequence <tablename>_id_seq;
3) vi <tablename>-DUMP.sql
   change your varchar(50) to varchar(80)
4) psql
   #\i <tablename>-DUMP.sql

There you go

> 
> Tanks
> 
> 
> ------------------------------ 
> http://www.ecolo.be 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr