Re: Does this table exist?
От | KuroiNeko |
---|---|
Тема | Re: Does this table exist? |
Дата | |
Msg-id | 3A01DDCF.nailY82KW4V8@ed.ed обсуждение исходный текст |
Ответ на | Does this table exist? (Alvaro Herrera <alvherre@protecne.cl>) |
Список | pgsql-general |
Alvaro, > Now, I'm building a database to hold customer data that needs to be > organized in a one-table-per-customer manner. No, I don't think there's > another way to do this Maybe, there's still a way to implement this in a theoretically correct manner? In fact, the amount of data (meaning cardinal number, I guess) doesn't matter that much. Of course, you can always query data dictionary (system tables) to find out whether particular table exists, but you're not guaranteed to have these tables always the same, little bits may change between releases. You can split large tables `horizontally,' ie store relatively old data in bigger, `archive' tables, and newer data in smaller, `live' ones. -- contaminated fish and microchips huge supertankers on Arabian trips oily propaganda from the leaders' lips all about the future there's people over here, people over there everybody's looking for a little more air crossing all the borders just to take their share planning for the future Rainbow, Difficult to Cure
В списке pgsql-general по дате отправления: