Bhavik <[EMAIL PROTECTED]> 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° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
