Re: Change size of a field - Mailing list pgsql-sql

On Fri, 26 Jul 2002, Achilleus Mantzios wrote:

I forgot!

> 1) % pg_dump -t <tablename> <dbname> > <tablename>-DUMP.sql
> 2) % psql
>    # drop sequence <tablename>_id_seq;

==>> # drop table <tablename>;

> 3) vi <tablename>-DUMP.sql
>    change your varchar(50) to varchar(80)
> 4) psql
>    #\i <tablename>-DUMP.sql

-- 
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