Type alias BindWithName

BindWithName: BindParameter & {
    name: string;
}

Provides the ability to Bind a parameter with a name that will be used

This is very useful for the output values

Type declaration

  • name: string

Example

const title = 'Good Omens';
const author = 'Terry Pratchett & Neil Gaiman';
const pages = 288;
const bind = {
name: 'id',
dir: BIND_OUT,
type: NUMBER,
};
const query = sql`INSERT INTO books (TITLE, AUTHOR, PAGES)
VALUES (${title}, ${author}, ${pages})
RETURNING ID into (${bind})`;

Generated using TypeDoc