Living Lion

PostgreSQL: Change column casting type to another type

Because there have been a few times that I have needed to adjust a column in PostgreSQL from one type of casting to another I am going to put it here so I can find it again and for anyone else that may be looking to do the same thing.

ALTER TABLE table_name ALTER COLUMN column_name TYPE INTEGER USING column_name::INTEGER

«Miggo Strap and Wrap for DSLR Cameras – Review»Motorola Droid Turbo – Disable QI charging popup overlay