problem in modifing column datatype of a table
Started by Durga Prasad Mohapatraover 21 years ago2 messagesgeneral
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
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/