Re: [GENERAL] Add columns

2006-01-03 Thread Tom Lane
P G <[EMAIL PROTECTED]> writes: > I see that one can add a new column to an existing > table. The documentation was not clear on how > efficient this operation would be. > Does PostgreSQL make a copy of the entire table when > adding a new column? Or does it simply use extra > space in the data

[GENERAL] Add columns

2006-01-03 Thread P G
I see that one can add a new column to an existing table. The documentation was not clear on how efficient this operation would be. Does PostgreSQL make a copy of the entire table when adding a new column? Or does it simply use extra space in the data blocks to add the new column?