Add columns

From: P G <pgress5(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Add columns
Date: 2006-01-03 17:19:49
Message-ID: 20060103171949.8521.qmail@web35402.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?


__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-01-03 17:30:28 Re: who has some document about extending postgresql
Previous Message Alejandro D. Burne 2006-01-03 17:12:53 Re: Visual FoxPro 9 ODBC errors