Re: alter column witdh - Mailing list pgsql-sql

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