matthewmturner commented on PR #2094: URL: https://github.com/apache/arrow-datafusion/pull/2094#issuecomment-1087853135
Given there isnt a sql parameter in postgres for specifying the database for a schema (it uses the current active db - https://www.postgresql.org/docs/current/sql-createschema.html) i think we could do one or both of the following: - to align with postgres add the notion of active catalog and create schema within that. this will require adding a command to update the active catalog. - qualify the schema names. i.e. `CREATE SCHEMA abc` continues in current / active catalog but then we also allow `CREATE SCHEMA my_catalog.abc` which would create a schema in the specified catalog. i personally think the second approach would align well with how catalogs / schemas are set using `CREATE TABLE`. Then we could always add more postgres like functionality as a second step. @alamb @jychen7 what do you think? -- 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]
