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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
