RE: Change varchar lenght

Eduardo,

Since you are changing the table definition, I would do the following.
1. Make a temp table "identical to the original table1 except for the larger
varchar size."
2. Copy table1 to the temp table.
3. Drop table1.
4. Create new table1 identical to temp table.
5. Copy temp table to table1.
6. Drop temp table.

I am a fairly new user, so there may be a better way to do this.

Good Luck,
dale(dot)sykora(at)compaq(dot)com

-----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