Re: What is exactly a schema?

marcelo schrieb am 14.07.2017 um 13:59:
> Could I select a specific schema in the connection string? Say, by example database=mydb.schemanumbertwo ?

The JDBC driver does indeed support that:

jdbc:postgresql://localhost/somedatabase?currentSchema=some_schema

I think in the backround it then simply runs a

set search_path = some_schema;

after the connection has been established.