Re: How do I change column details

On Wed, Mar 10, 2004 at 00:42:18 +0000,
Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> wrote:
> Hi
>
> I have a MySQL application which I am porting to Postgres. I have been
> asked to increase the size of a varchar column from 200 chars to 2000.
>
> Normally, in MySQL/Oracle this is done with the alter table modify
> column command.
>
> How do I do this in Postgres?
>
> I have just renamed the column, created the new one, copied the data
> into it and dropped the renamed column. Is the only way?

For varchar there is a way to do this by munging the system catalogs.
The method has been described on the list previously and should be in the
archives.

You might consider changing the column type to TEXT so that you don't
have to go through this again. If you really need it limited to keep
the app from barfing, use a constraint. That will be much easier to
update in the future.