Enable extension

sql

CREATE EXTENSION IF NOT EXISTS pgcrypto;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Views, Functions, Triggers, and Extensions

Create a new database in the cluster.

Open In sheetsql1 tag match

Create a namespace for objects.

Open In sheetsql1 tag match

Create a database with explicit owner and template.

Open In sheetsql1 tag match

Create a basic table with primary key and defaults.

Open In sheetsql1 tag match

Use a SQL-standard identity column instead of serial.

Open In sheetsql1 tag match

Create a role that can log in.

Open In sheetsql1 tag match