PostgrestTransformBuilder | /src/lib/PostgrestTransformBuilder.ts | postgrest@1.1.0

class PostgrestTransformBuilder

import { PostgrestTransformBuilder } from "https://deno.land/x/postgrest@1.1.0/src/lib/PostgrestTransformBuilder.ts";

Post-filters (transforms)

Type Parameters

Methods

abortSignal(signal: AbortSignal): this

Sets the AbortSignal for the fetch request.

csv(): PromiseLike<PostgrestSingleResponse<string>>

Set the response type to CSV.

limit(count: number, unnamed 1?: { foreignTable?: string; }): this

Limits the result with the specified count.

maybeSingle(): PromiseLike<PostgrestMaybeSingleResponse<T>>

Retrieves at most one row from the result. Result must be at most one row (e.g. using eq on a UNIQUE column), otherwise this will result in an error.

order(column: keyof T, unnamed 1?: { ascending?: boolean; nullsFirst?: boolean; foreignTable?: string; }): this

Orders the result with the specified column.

range(

from: number,

to: number,

unnamed 2?: { foreignTable?: string; },

): this

Limits the result to rows within the specified range, inclusive.

select(columns?): this

Performs vertical filtering with SELECT.

single(): PromiseLike<PostgrestSingleResponse<T>>

Retrieves only one row from the result. Result must be one row (e.g. using limit), otherwise this will result in an error.