operationsengineer1@yahoo.com wrote:
> 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.
hi,
you can try with CREATE TABLE AS
(http://www.postgresql.org/docs/7.4/static/sql-createtableas.html) in the
SQL editor and then rename the table, You can re-order and change the type
of your columns as you want without loosing your existing values...
HTH
--
MaXX