CREATE DATABASE IN CrateDB

Sorry for the basic question, but how do you create a database in CrateDB? I can create tables in the UI but I can’t create a database and it must be that I am missing something. Thanks in advance.

Todd

Hi @Todd_Bryant

Welcome to the CrateDB Community! :slight_smile:

Like MySQL and unlike PostgreSQL, CrateDB doesn’t support CREATE DATABASE as an additional differentiation layer between concerns. There is only one database within CrateDB called doc.

CrateDB does support Schemas and you can grant access on a cluster, schema or table level.

best regards
Georg

1 Like