I don't believe you can change the size of a column once it's created. The best way is to recreate it. Take a look at SELECT INTO for creating a backup table easily. Then recreate the original table and INSERT INTO <original> SELECT * FROM <temp>. Should be fairly painless.
-----Original Message-----
From: Eduardo [mailto:ekotuja@brasilnet.net]
Sent: Monday, September 11, 2000 3:17 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Change varchar lenght
How can I change a field that is varchar(50) to varchar(500) ??
I did not find in docs. And did not find that option in pgaccess .
Thanks,
Eduardo K