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







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
Tue, 30 Jan 2001 10:22:23 +0700
"Jaruwan Laongmal" <jaruwan@gits.net.th>
How to modify type in table?
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
                              =====================================


Tue, 30 Jan 2001 11:49:41 +0800 (PHT)
Manuel Cabido <manny@msuiit.edu.ph>
Re: How to modify type in table?
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
--------------------------------------------------------------------------

Mon, 5 Feb 2001 18:39:19 +0100
"Albert REINER" <areiner@tph.tuwien.ac.at>
Re: How to modify type in table?
>    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

Tue, 06 Feb 2001 04:48:47 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: How to modify type in table?