Re: alter column witdh

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