alter column type

From: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
To: "Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: alter column type
Date: 2006-04-10 09:43:38
Message-ID: 00e301c65c83$3f49a520$cd00000a@sandhyar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sandhya 2006-04-10 13:18:12 creating user
Previous Message Andy Shellam 2006-04-10 09:00:20 Re: I have a question?