Search Postgresql Archives

Re: What is exactly a schema?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



marcelo wrote:
The question is not trivial. Could I maintain two or three separate/distinct "versions" of same
database using one schema for every of them?
Could some tables (in the public schema) be shared among all the schemas?



Yes and yes. In the Postgresql world, the word "schema" is maybe unfortunately overloaded, but whenever you read it think "namespace". In fact, in the systems catalog there are columns named "namespace" that store data referring to named schemas.

-- B




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux