FIND YOUR NEXT FEW LINES
The snippet library.
Small, practical examples. Search by task or narrow things down below.
5 snippets foundClear filters
Compute a generated column
Store inputs and derive a value from them.
generated column✓ Tested
Create a STRICT table
Require values compatible with declared column types.
STRICT✓ Tested
Enable and use foreign keys
Turn on relationship enforcement for the connection.
foreign keys✓ Tested
Read values from an inserted row
Use RETURNING to retrieve an automatically assigned row ID.
RETURNING✓ Tested
Update a row on conflict
Use a primary key to insert or update one value.
upsert✓ Tested