i've had to change the data types of several columns
in pgadmin3. most of the time, the data type is
unavailable (shaded out) and, therefore, i have to
delete the whole column and recreate it with the
correct data type. there is no data in the table.
is there a way to change the data type in pgadmin3 w/o
having to recreate the column?
i want to avoid recreating the column b/c it then
messes up my column order.
if anybody knows how to manipulate the order of
columns, i'd be interested in learning that, too. ;-)
i've already had to do some recreating.
tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com