Re: namespace in pgsql
От | Andreas Kretschmer |
---|---|
Тема | Re: namespace in pgsql |
Дата | |
Msg-id | 20080925100522.GA14009@tux обсуждение исходный текст |
Ответ на | namespace in pgsql (Bhavik <bhavikdbavishi@gmail.com>) |
Список | pgsql-general |
Bhavik <bhavikdbavishi@gmail.com> schrieb: > Hi, > > I am newbie for pgsql..... Im using Solaris..... > > 1) Is it possible to have namespace like in OOP, in pgsql query..... > means as I know we can reference table or its column with fashion like > <schema>.<table_name>, but is it possible like > <db_name>.<schema>.<table_name> ??? No, you can't acces across multiple db's. > > 2) Is it fine if I store all data in one db ( well most of the table > with 2000+ rows ) ? OR better to created 2-3 dbs and store those > tables... Use one DB. You can store millions of tables and billions of rows per table in one DB, no problem. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: