Postgres Pro
Downloads
Home   >   mailing lists

changing column data types - Mailing list pgsql-novice

From Derek
Subject changing column data types
Date
Msg-id 001901c09c1d$41eb53e0$0500a8c0@derek
Whole thread Raw
In response to My apologies...  (Ken Corey <ken@kencorey.com>)
Responses Re: changing column data types  (ERIC Lawson - x52010 <eric@bioeng.washington.edu>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Richard Ehrlich
Date:
Subject: Printing PostgreSQL reports
Next
From: ERIC Lawson - x52010
Date:
Subject: Re: changing column data types