Re: [GENERAL] Adding fields on the fly

2003-10-22 Thread Peter Eisentraut
Gail Zacharias writes: > Is this even possible? Is ALTER TABLE supported? Yes. (RTFM) > If so, what performance characteristics can I expect? Compared to, say, > inserting a record, can I expect this to be 10 times slower? 1000 times > slower? What does the performance depend on? Number of row

[GENERAL] Adding fields on the fly

2003-10-22 Thread Gail Zacharias
I am investigating the possibility of using pgsql as the database in an application. I have some unusual requirements that I'd like to ask you all about. I apologize in advance if my terminology is a little "off", I'm not familiar with pgsql (yet). My first requirement is that I need to be abl