Skip site navigation (1) Skip section navigation (2)

Re: Can one alter the format of a numeric column?

From: Chris Green <chris(at)areti(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can one alter the format of a numeric column?
Date: 2004-11-27 18:49:31
Message-ID: 20041127184931.GB9899@areti.co.uk (view raw or flat)
Thread:
Lists: pgsql-general
On Sat, Nov 27, 2004 at 10:50:47AM -0700, Michael Fuhr wrote:
> On Sat, Nov 27, 2004 at 05:29:42PM +0000, Chris Green wrote:
> 
> > Can one alter the precision of a numeric column?
> > 
> > I want to reduce the precision of a column from 20,4 to 20,2.
> 
> In PostgreSQL 8.0 (currently in beta) you can use ALTER TABLE
> to alter a column's type.  For previous versions see the FAQ:
> 
> http://www.postgresql.org/docs/faqs/FAQ.html#4.4
> 
OK, thanks.  That means I need to dump the data and re-import it.
Or, no, I can use an UPDATE to do it I guess.

-- 
Chris Green (chris(at)areti(dot)co(dot)uk)

    "Never ascribe to malice, that which can be explained by incompetence."

In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2004-11-27 19:29:48
Subject: Re: row-level deadlock problem
Previous:From: Eric EDate: 2004-11-27 18:46:34
Subject: ODBC driver troubles

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group