See the CREATE DOMAIN statement for details.

    You cannot use the FROM path-name clause when embedding a
    CREATE DOMAIN statement in a CREATE DATABASE statement. You
    can, however, issue a separate CREATE DOMAIN statement following
    the CREATE DATABASE statement. You can also describe the domain
    directly in the CREATE DATABASE statement.

    If you want to specify a collating sequence in your embedded
    CREATE DOMAIN statement, you must first specify a CREATE
    COLLATING SEQUENCE statement in the same CREATE DATABASE
    statement.