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