changing column data types

From: "Derek" <derek(dot)mailer(at)virgin(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: changing column data types
Date: 2001-02-21 15:45:03
Message-ID: 001901c09c1d$41eb53e0$0500a8c0@derek
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

Excuse my ignorance, but I'm used to MySQL and I'm having problems trying to
convert a few columns from varchar to numeric. I attempted to get around
the problem by creating a new numeric column, but pgsql didn't like it when
I tried to copy the varchar column info into the numeric one.

Is there a painless way of changing a column type?

Thanks in advance for any help offered

Derek

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ERIC Lawson - x52010 2001-02-21 16:50:22 Re: changing column data types
Previous Message Rob Arnold 2001-02-21 02:31:26 Re: copying tables

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-02-21 16:42:07 two tables - foreign keys referring to each other...]
Previous Message Grigoriy G. Vovk 2001-02-21 09:02:44 Re: two tables - foreign keys referring to each other...