RaigorJiang opened a new issue #13638:
URL: https://github.com/apache/shardingsphere/issues/13638


   Hi community,
   
   At present, the terms `database` and `schema` have the same meaning in 
proxy, which stands for `logical database`.
   This is no problem when proxy acts as a proxy for mysql. But in PostgreSQL, 
schema has another meaning.
   For example, each database in PostgreSQL has a default schema `public`, if 
the table `t_order` is created under the public schema, then:
   `select * from t_order` and `select * from public.t_order` are equivalent.
   But now, `public.t_order` cannot be supported.
   
   So, maybe we should reconsider the definition of schema?
   
   refer to:
   - https://www.postgresql.org/docs/current/managing-databases.html
   - https://www.postgresql.org/docs/current/ddl-schemas.html
   - https://www.postgresql.org/docs/current/sql-createschema.html


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to