@nodef/extra-sql@0.1.2
Built and signed on GitHub Actions
Built and signed on GitHub Actions

latest

Generates SQL commands for creating tables, inserting data, and performing operations like text search and matching in PostgreSQL databases.

Published

2 weeks ago (0.1.2)

function createTableData



createTableData(table: string,
cols: ColumnTypes,
pkeys?: string | Iterable<string>,
): QueryData

Generate SQL command for creating a table with data.

Parameters



table: string

table name



cols: ColumnTypes

columns with their types {name: type}

optional



pkeys: string | Iterable<string>

primary key(s)

QueryData

query data for creating the table {query, data}

Add Package

deno add jsr:@nodef/extra-sql

Import symbol

import { createTableData } from "@nodef/extra-sql";

Import directly with a jsr specifier

import { createTableData } from "jsr:@nodef/extra-sql";

Add Package

pnpm i jsr:@nodef/extra-sql

or (using pnpm 10.8 or older)

pnpm dlx jsr add @nodef/extra-sql

Import symbol

import { createTableData } from "@nodef/extra-sql";

Add Package

yarn add jsr:@nodef/extra-sql

or (using Yarn 4.8 or older)

yarn dlx jsr add @nodef/extra-sql

Import symbol

import { createTableData } from "@nodef/extra-sql";

Add Package

npx jsr add @nodef/extra-sql

Import symbol

import { createTableData } from "@nodef/extra-sql";

Add Package

bunx jsr add @nodef/extra-sql

Import symbol

import { createTableData } from "@nodef/extra-sql";