On Thu, Jan 18, 2007 at 06:27:04AM -0800, af300wsm@xxxxxxxxx wrote: > ksherlock@xxxxxxxxx wrote: > > Using ALTER TABLE <table> ALTER <field> TYPE VARCHAR(<newsize>) to > > change the size requires scanning the entire table. For large tables, > > this will be much slower than the pg_attribute query. Both will get > > the job done. > > 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? ALTER TABLE, to be correct, actually has to check the entire table to make sure it's ok. By doing it directly you're basically telling the DB it's OK. For making a varchar column longer it's safe though, and the easiest way. Have a ncie day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
