Re: Self creating tables
От | Matt Miller |
---|---|
Тема | Re: Self creating tables |
Дата | |
Msg-id | 1125682397.3076.12.camel@dbamm01-linux обсуждение исходный текст |
Ответ на | Self creating tables (Bob Pawley <rjpawley@shaw.ca>) |
Список | pgsql-general |
On Fri, 2005-09-02 at 09:51 -0700, Bob Pawley wrote: > regarding the setting up of tables > ... > I could create a separate table for each category of elements ... The > challenge is ... a distinct possibility of the user inserting an > element that we haven’t considered. The above approach would force > him to stop what he is doing and create a new table(s) for the new > element(s). Your application should be able to create tables for the user. The user should not need to exit your app, get to an SQL command line, and issue CREATE TABLE statements. The CREATE TABLE statement is just another SQL statement, like SELECT, INSERT, etc. Try using your API (whatever that is -- this is another decision you may still have to make) to issue CREATE TABLE and see how it works. > in my Postgresql book or through the Postgre on-line help. Typically the database is referred to either as "Postgres" or as "PostgreSQL," but not as "Postgre."
В списке pgsql-general по дате отправления: