| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: alter table |
| Date: | 2003-03-24 19:21:47 |
| Message-ID: | 1048533707.13798.320.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Morozovsky | 2003-03-25 00:20:29 | Re: Installed OpenSSL but still cannot install PostgreSQL |
| Previous Message | Tatiana Motova | 2003-03-24 19:17:01 | Re: pg_dump problem |