Thread: alter table

On Mon, 2003-03-24 at 14:05, Jodi Kanter wrote:
> Is it possible to modify a column data type? I don't see it in the docs
> but thought I remembered something crossing this list regarding a modify
> command?
> Thanks
> Jodi
>

You can do it by hacking at reltype in pg_class, though this will
probably only work if your data types are binary compatible, and even
then there might be some issues. Read thoroughly chapter 3 of the
developers guide and make sure to test on a development database before
trying to do this on anything resembling a production system.

Robert Treat