Skip to main content
Home

Built and signed on GitHub Actions

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)
T
ColumnTypes

Types for columns in a table.

T
ColumnWeights

Weights for columns in a table (for a tsvector).

f
createIndex

Generate SQL command for CREATE INDEX.

I
CreateIndexOptions

Options for creating an index.

f
createTable

Generate SQL command for CREATE TABLE.

f
createTableData

Generate SQL command for creating a table with data.

I
CreateTableOptions

Options for creating a table.

f
createView

Generate SQL command for CREATE VIEW.

f
deleteData

Generate SQL command for deleting data.

f
insertInto

Generates SQL command for INSERT INTO using an array of values.

f
insertIntoData

Generate SQL command for inserting data.

I
InsertIntoOptions

Options for inserting into a table.

f
matchTsquery

Generate SQL query for matching words with tsquery.

I
MatchTsqueryOptions

Options for matching with tsquery.

v
OPERAND_COUNT

Number of operands used with an SQL operator.

v
OPERATORS

Set of operators in SQL.

I
QueryData

Query data with SQL and parameters.

T
RowData

Data for a row in a table.

f
selectData

Generate SQL command for selecting data.

f
selectTsquery

Generate SQL command for SELECT with tsquery.

I
SelectTsqueryOptions

Options for selecting with tsquery.

f
setupTable

Generate SQL commands to set up a table (create, insert, index).

f
setupTableIndex

Generate SQL commands for setting up table indexes and views.

I
SetupTableIndexOptions

Options for setting up table indexes.

I
SetupTableOptions

Options for setting up a table.

f
tableExists

Generate SQL command to check if a table exists.

f
updateData

Generate SQL command for updating data.

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.