Home > mailing lists

alter column type - Mailing list pgsql-admin

From	sandhya
Subject	alter column type
Date	April 10, 2006 09:37:22
Msg-id	00e301c65c83$3f49a520$cd00000a@sandhyar Whole thread Raw
Responses	Re: alter column type
List	pgsql-admin

Hi..

If i want to change the datatype of a column in a table.....What are all the thigs i need to take care off.

After somany records insertion if i change the datatype of the column..What will be the effect of it.

Please tell me /give suggestion what needs to be cosider at the time of changing column type of a table.

Incase of int to char/varchar/text/ etc.

What are the different datatypes we should think about?

Thank you,

Sandhya

From: "Andy Shellam"
Date: 10 April 2006, 09:00:31
Subject: Re: I have a question?

From: "sandhya"
Date: 10 April 2006, 13:15:45
Subject: creating user