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(at)brasilnet(dot)net]
Sent: Monday, September 11, 2000 3:17 PM
To: pgsql-novice(at)postgresql(dot)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