Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to modify type in table?

How to modify type in table?

From
"Jaruwan Laongmal"
Date:
Dear Sir.
Would you like to inform me how to modify type in table?
For example , I define type as varchar(14) , but I want to modify to varchar(120). How to do this.
 
Thank you so much
Jaruwan

Re: How to modify type in table?

From
Manuel Cabido
Date:
Hi there,
  I am compiling postgresql 7.1beta4. How would i change the 8k row
limit?

--                              Manny C. Cabido                             ====================================
                    e-mail:manny@tinago.msuiit.edu.ph                                    manny@sun.msuiit.edu.ph
                    =====================================

Re: How to modify type in table?

From
Thomas Lockhart
Date:
>    I am compiling postgresql 7.1beta4. How would i change the 8k row
> limit?

There is no 8k row limit anymore. But if there were, you would modify a
#define in the source code and recompile (check the docs for more
details).
                  - Thomas