I need some help...
I created a table with postgresql. Is there any way we can alter the table data type without losing the data?
Example:
What I did was:
create table tablename (name text, age int);
Now I want the name to be an array of names which do this:
names text[]
is there anyway I can alter the data type after I created the table?
Please help.
Chris
I created a table with postgresql. Is there any way we can alter the table data type without losing the data?
Example:
What I did was:
create table tablename (name text, age int);
Now I want the name to be an array of names which do this:
names text[]
is there anyway I can alter the data type after I created the table?
Please help.
Chris