Thank you.
Now I have a related question.
Could I select a specific schema in the connection string? Say, by
example database=mydb.schemanumbertwo ?
I'm asking this because I will be using Devart's dotConnect and Entity
developer to access the database. I have not full control, so I cannot
set the search path immediately after the connection.
If the first example is possible, I will replace the schema name on the
fly, before connection attempt.
TIA
On 14/07/17 07:58, Berend Tober wrote:
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
