Catalog

Functions & routines

Name: Nexoxa Bridge
Author: Nexoxa

Scalar and table functions with signatures.

The story

These pages use illustrative scenarios to walk through real workbench panels. Sidebar labels, Bridge paths, and connection schemes match the app; characters and timelines are examples for learning.

Trigger calls obscure function, opens Functions — signatures and bodies — jumps to Query lab to read source.

The Catalog panel Functions is where Bridge turns raw metadata into decisions — counts, definitions, dependencies, and links into the grid or Query lab. No information_schema archaeology; no guessing which mat view is stale.

Open Functions from the left sidebar after you connect; everything here reflects the live connection, not a cached export from yesterday.

Bridge path: /database/functions

Step 1

Scalar and table functions

calculate_tax(amount numeric) returns numeric — signature mismatch in app explained.
Jump to body.

Scalar and table functions with signatures. /database/functions. Routines with signatures.

Step 2

Read function body

Body in lab — find off-by-one. Patch migration planned.
Triggers panel cross-check.

Open in Query lab. Pair with Triggers.

Step 3

Who calls whom

Function used by three triggers — change ripples listed.
Safer refactors.

Dependency introspection where engine exposes it.

This panel appears in the Nexoxa Bridge left sidebar after you connect with the matching connection URL. See the connection docs above for postgresql://, ssh://, sftp://, s3://, or smtp:// examples.

Related connections

Database connection URLs