Re: alter column witdh - Mailing list pgsql-sql

From Frank Bax
Subject Re: alter column witdh
Date
Msg-id 5.2.0.9.0.20030527111114.037fd930@pop6.sympatico.ca
Whole thread Raw
In response to alter column witdh  ("Eric Anderson Vianet SAO" <eric@vianet-express.com.br>)
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 



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: little doubt
Next
From: Chadwick Rolfs
Date:
Subject: Re: [PHP] faster output from php and postgres