Add columns - Mailing list pgsql-general

From P G
Subject Add columns
Date
Msg-id 20060103171949.8521.qmail@web35402.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Visual FoxPro 9 ODBC errors  (MargaretGillon@chromalloy.com)
Responses Re: Add columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-general by date:

Previous
From: "Alejandro D. Burne"
Date:
Subject: Re: Visual FoxPro 9 ODBC errors
Next
From: SCassidy@overlandstorage.com
Date:
Subject: Re: pg_dump error codes