On Thu, Dec 08, 2005 at 03:12:07PM +0800, Noel Doydora wrote:
> Below is the message I receive when I try to alter the data type of
> a column to "date". I had to drop the column and add it again just
> so I can set its data type to "date". How do I change a column's
> data type to "date" without dropping and then creating it again?
See the USING clause in the ALTER TABLE documentation:
http://www.postgresql.org/docs/8.0/interactive/sql-altertable.html
--
Michael Fuhr