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: [HACKERS] 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
"Albert REINER"
Date:
Saluton,

On Tue, Jan 30, 2001 at 10:22:23AM +0700, Jaruwan Laongmal wrote:
> 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.

If it is not too much data, the easiest would be to use pg_dump to
dump the database (or just the table), edit the definition, and feed
the changed file to psql in order to get the data back. Or you can
create a different table with the correct structure, copy the data
there, drop the old table, rename the new one to the correct one.

Albert.


-- 

--------------------------------------------------------------------------
Albert Reiner                                   <areiner@tph.tuwien.ac.at>
Deutsch       *       English       *       Esperanto       *       Latine
--------------------------------------------------------------------------


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