Thread: How to modify type in table?
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
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
=====================================
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 --------------------------------------------------------------------------
> 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