38.1. Creating a Schema #

  1. In the navigation panel, go to Databases.

  2. (Optional) To display system databases, turn on Show system databases.

  3. Click the name of the database.

  4. In the top-right corner of the page, click Create schema.

  5. Specify parameters of the new schema (parameters marked with an asterisk are required):

    • Name.

    • Owner.

    • lock_timeout, s: Abort any statement that waits longer than the specified time while attempting to acquire a lock on a table, index, row, or other database object. The time limit applies separately to each lock acquisition attempt.

      For more information about this parameter, refer to the official Postgres Pro documentation.

  6. Click Create.