On 7/14/2017 4:59 AM, marcelo wrote:
Now I have a related question.
Could I select a specific schema in the connection string? Say, by
example database=mydb.schemanumbertwo ?
the default search_path is $user,public
so if you connect with different SQL usernames for your different
schemas, and have all your common tables in PUBLIC, then it will just
fall out. you'll need to be careful with permissions, of course.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
