openGauss icon

openGauss

Get, add and update data in openGauss

Actions6

Database → Select

AI-generated

Summary

Select rows from an openGauss database table with optional filtering, sorting, and limiting

Inputs

  • schema (required) — The schema that contains the table you want to read from
  • table (required) — The table you want to read from
  • returnAll — Whether to return all results or only up to a given limit
  • limit — Max number of results to return
  • where — If not set, all rows will be selected; collection of condition objects
  • combineConditions — Logical operator to combine multiple conditions (AND or OR)
  • sort — Collection of sort rules defining column and direction
  • options — Additional options such as output columns, query parameters, etc.

Output shape

an array of records (one per returned row)

If returnAll is false the result is limited by the Limit value; empty result yields an empty array; errors may be propagated depending on continueOnFail

Examples

Example 1: Retrieve up to 100 rows from the users table where id equals 42

Set Table to 'users', add a condition 'id = 42', set Limit to 100

Example 2: Fetch all rows from a specific schema using a condition and optional sorting

Enable Return All, optionally set Output Columns, add condition(s), optionally define Sort rules

Links

Discussion