Describe Redis cache table
describe_redis_cache_tableInspect a Redis-backed foreign table in PostgreSQL, returning its server, key type, prefix, TTL, and column details.
Instructions
Describe one foreign table backed by redis_fdw: which server it's mapped to, the Redis-side key structure (hash / list / string / set / zset), key-prefix, TTL, and SQL-side column shape. Raises an error when the table doesn't exist or isn't backed by redis_fdw. Returns an object with schema, name, server, key_type, key_prefix, ttl_seconds, columns (list of {name, data_type}), and options (the full foreign-table options dict).
Example: describe_redis_cache_table(schema='public', table='sessions_cache')
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| schema | Yes | ||
| server | Yes | ||
| columns | Yes | ||
| options | Yes | ||
| key_type | Yes | ||
| key_prefix | Yes | ||
| ttl_seconds | Yes |