4 ms·
We call a "schema" what they call a "database" in MySQL. The overall PostgreSQL documentation is pretty good. Note that you usually want to prefix your table n
by einhverfr 14y ago
We call a "schema" what they call a "database" in MySQL.
The overall PostgreSQL documentation is pretty good. Note that you usually want to prefix your table names, etc, with schema names so instead of create table foo, you have create table myschema.foo
Note that roles and users cannot be assigned to schemas (or databases either) since they are cluster-global.