postgres_select
Select data from a PostgreSQL table with optional filtering, sorting, and pagination.
Instructions
Select data from a table with optional filtering, sorting, and pagination
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of rows to return | |
| where | No | WHERE clause conditions as key-value pairs | |
| offset | No | Number of rows to skip | |
| columns | No | Columns to select (leave empty for all columns) | |
| order_by | No | Column to order by | |
| table_name | Yes | Name of the table to select from | |
| order_direction | No | Order direction |