## Synopsis

Use the `CREATE EXTENSION` statement to load an extension into a database.

## Syntax

{{%ebnf%}}
  create_extension
{{%/ebnf%}}

## Semantics

- `SCHEMA`, `VERSION`, and `CASCADE` may be reordered.

## Examples

```plpgsql
CREATE SCHEMA myschema;
CREATE EXTENSION pgcrypto WITH SCHEMA myschema VERSION '1.3';
```

```output
CREATE EXTENSION
```

```plpgsql
CREATE EXTENSION IF NOT EXISTS earthdistance CASCADE;
```

```output
NOTICE:  installing required extension "cube"
CREATE EXTENSION
```

## See also

- [PostgreSQL Extensions](../../../../../additional-features/pg-extensions/)
- [DROP EXTENSION](../ddl_drop_extension)