| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | ROUWEZ Stephane <stephane(dot)rouwez(at)ecolo(dot)be> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>, LESNE Philippe <philippe(dot)lesne(at)ecolo(dot)be> |
| Subject: | Re: Change size of a field |
| Date: | 2002-07-26 13:20:55 |
| Message-ID: | Pine.LNX.4.44.0207261619410.7428-100000@matrix.gatewaynet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Elielson Fontanezi | 2002-07-26 13:27:58 | set DateStyle to 'SQL' |
| Previous Message | Achilleus Mantzios | 2002-07-26 12:49:41 | Re: Change size of a field |