e04ed9c211
CF: Deploy Dev Docs / deploy (push) Has been cancelled
Sync Labels / build (push) Has been cancelled
tests / unit tests (macos-latest) (push) Has been cancelled
tests / unit tests (windows-latest) (push) Has been cancelled
tests / unit tests (ubuntu-latest) (push) Has been cancelled
1.5 KiB
1.5 KiB
title, type, weight, description
| title | type | weight | description |
|---|---|---|---|
| postgres-list-views | docs | 1 | The "postgres-list-views" tool lists views in a Postgres database, with a default limit of 50 rows. |
About
The postgres-list-views tool retrieves a list of top N (default 50) views from
a Postgres database, excluding those in system schemas (pg_catalog,
information_schema).
postgres-list-views lists detailed view information (schemaname, viewname,
ownername, definition) as JSON for views in a database. The tool takes the following input
parameters:
view_name(optional): A string pattern to filter view names. Default:""schema_name(optional): A string pattern to filter schema names. Default:""limit(optional): The maximum number of rows to return. Default:50.
Compatible Sources
{{< compatible-sources others="integrations/alloydb, integrations/cloud-sql-pg">}}
Example
kind: tool
name: list_views
type: postgres-list-views
source: cloudsql-pg-source
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be "postgres-list-views". |
| source | string | true | Name of the source the SQL should execute on. |
| description | string | false | Description of the tool that is passed to the agent. |