Re: Increasing Table Column Size in 7.0 Syntax - Mailing list pgsql-general

This requires you to change NAMEDATALEN in src/include/postgres_ext.h.

Note this requires a recompile, initdb, createdb, etc.

Also note that databases with different NAMEDATALEN's can't interoperate.

Wade
>
> Hello,
>
> Looking at the docs for pgsql I have only found stuff on altering a table
> for default and renaming a column but nothing on changing the size. I want
> to increase the size of a field from 2048 to 4096.
>
> What is the syntax for this?
>
> Thanks,
> J
>
>