PostgrestQueryBuilder
§Type Parameters
§Constructors
§Properties
§Methods
Perform a DELETE on the table or view.
By default, deleted rows are not returned. To return it, chain the call
with .select()
after filters.
- Named parameters
- Count algorithm to use to count deleted rows.
"exact"
: Exact but slow count algorithm. Performs a COUNT(*)
under the
hood.
"planned"
: Approximated but fast count algorithm. Uses the Postgres
statistics under the hood.
"estimated"
: Uses exact count for low numbers and planned count for high
numbers.
Perform a SELECT query on the table or view.
- The columns to retrieve, separated by commas. Columns can be renamed when returned with
customName:columnName
- Named parameters
- When set to
true
,data
will not be returned. Useful if you only need the count.
- Count algorithm to use to count rows in the table or view.
"exact"
: Exact but slow count algorithm. Performs a COUNT(*)
under the
hood.
"planned"
: Approximated but fast count algorithm. Uses the Postgres
statistics under the hood.
"estimated"
: Uses exact count for low numbers and planned count for high
numbers.
Perform an UPDATE on the table or view.
By default, updated rows are not returned. To return it, chain the call
with .select()
after filters.
- The values to update with
- Named parameters
- Count algorithm to use to count updated rows.
"exact"
: Exact but slow count algorithm. Performs a COUNT(*)
under the
hood.
"planned"
: Approximated but fast count algorithm. Uses the Postgres
statistics under the hood.
"estimated"
: Uses exact count for low numbers and planned count for high
numbers.