problem in modifing column datatype of a table

От:

"Durga Prasad Mohapatra" <durgamohapatra@fastmail.fm>

Дата:

24 ноября 2004 г. в 15:06:24

Hi,

  I am newbie in postgresql.I want to modify column datatype of a table
  how can i do it.
for example there is a column with datatype varchar, i want to change it
to text.
How can i.

Thanks
Regards
Durga

Re: problem in modifing column datatype of a table

От:

Peter Eisentraut <peter_e@gmx.net>

Дата:

24 ноября 2004 г. в 15:22:58

Durga Prasad Mohapatra wrote:
>   I am newbie in postgresql.I want to modify column datatype of a
> table how can i do it.
> for example there is a column with datatype varchar, i want to change
> it to text.
> How can i.

Before 8.0: Recreate the table and copy the data.
After 8.0: ALTER TABLE

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/