Skip to main content
Home
Browse packagesDocsSign in

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

latest
nodef/extra-sql

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

This package works with Node.js, DenoIt is unknown whether this package works with Cloudflare Workers, Bun, Browsers
It is unknown whether this package works with Cloudflare Workers
This package works with Node.js
This package works with Deno
It is unknown whether this package works with Bun
It is unknown whether this package works with Browsers
JSR Score
100%
Published
2 weeks ago (0.1.2)
function createTable
createTable(
name: string,
acc?: string,
): string

Generate SQL command for CREATE TABLE.

Examples

Example 1

xsql.createTable("plant", {name: "TEXT", type: "TEXT", age: "INT"});
// → CREATE TABLE IF NOT EXISTS "plant" ("name" TEXT, "type" TEXT, "age" INT);

xsql.createTable("animal", {name: "TEXT", type: "TEXT", age: "INT"}, {pk: "name"});
// → CREATE TABLE IF NOT EXISTS "animal" ("name" TEXT, "type" TEXT, "age" INT, PRIMARY KEY("name"));

Parameters

name: string

table name

columns {name: type}

optional
opt: CreateTableOptions

options {pk}

optional
acc: string =

string to accumulate to (internal use)

Return Type

SQL command for creating the table

New Ticket: Report package

Please provide a reason for reporting this package. We will review your report and take appropriate action.

Please review the JSR usage policy before submitting a report.

Add Package

deno add jsr:@nodef/extra-sql

Import symbol

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

Import directly with a jsr specifier

import { createTable } 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 { createTable } 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 { createTable } from "@nodef/extra-sql";

Add Package

npx jsr add @nodef/extra-sql

Import symbol

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

Add Package

bunx jsr add @nodef/extra-sql

Import symbol

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