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:
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 Herrera||Date: 2004-11-27 19:29:48|
|Subject: Re: row-level deadlock problem|
|Previous:||From: Eric E||Date: 2004-11-27 18:46:34|
|Subject: ODBC driver troubles|