marcelo <marcelo.nicolet@xxxxxxxxx> writes: > 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. Take a look at the PGOPTIONS env variable an/or libpq connect parameter variant. > > 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 >> >> >> -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
