Skip to main content
Module

x/windmill/mod.ts>pgSql

Windmill deno client (separated from the main repo because most of the code is auto-generated from the openapi and not worth committing)
windmill-labs/windmill-deno-client
Extremely Popular
Go to Latest
function pgSql
import { pgSql } from "https://deno.land/x/windmill@v1.79.0/mod.ts";

deno-postgres client API is very flexible: https://deno.land/x/postgres@v0.17.0/mod.ts?s=QueryClient

Examples

// Prepared Statements

const { rows } = await pgSql(db)`SELECT ID, NAME FROM CLIENTS WHERE ID = ${id}`;

Parameters

db: Resource<"postgresql">

the PostgreSQL resource to run sql query for

optional
asObjects = [UNSUPPORTED]