Re: Alter definition of a column

From: "ksherlock(at)gmail(dot)com" <ksherlock(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Alter definition of a column
Date: 2007-01-19 03:09:38
Message-ID: 1169176178.060207.149620@11g2000cwr.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


af300wsm(at)gmail(dot)com wrote:

> Thanks. Am I correct in assuming that this scanning of the entire
> table is done when I use the 'ALTER TABLE' command and not something I
> must do after it's done?

Yes, ALTAR TABLE ... scans through the entire table when it does the
update, it's not something you need to do.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Lambert 2007-01-19 03:46:52 Installing Postegres side-by-side with M$ SQL server
Previous Message Chris 2007-01-19 03:07:20 Re: uninstalling postgre sql on Fedora core 5